Converged logical and physical security

ABSTRACT

A security management system that includes a hierarchical security platform, converged IT and physical security management, unified credentialing, credential issuance and incident(s) management. An exemplary aspect of the invention also relates to physical and logical security management and information technology/network security management, with a credential issuance and integrity checking system as well as associated readers and printers of the credential. Still further aspects of the invention relate to obtaining, assembling and analyzing one or more of data, video information, image information, biometric information, sensor information, terrorist information, profile information, and/or other types of information to provide a comprehensive platform for all aspects of security management. A toolkit is also provided that allows complete management, integration, scalability, interoperability and centralized control of all aspects of security including personnel credentialing, personnel management, personnel tracking, task management, security system integration, security information exchange and scalability.

RELATED APPLICATION DATA

This application is a Continuation of U.S. patent application Ser. No.15/679,941, filed Aug. 17, 2017, which is a Continuation of U.S. patentapplication Ser. No. 15/409,780, filed Jan. 19, 2017, which isContinuation of U.S. patent application Ser. No. 15/187,208, filed Jun.20, 2016, which is a Continuation of U.S. patent application Ser. No.14/802,660, filed Jul. 17, 2015, now U.S. Pat. No. 9,400,881, which is aContinuation of U.S. patent application Ser. No. 13/314,335, filed Dec.8, 2011, which is a Continuation of U.S. patent application Ser. No.11/740,063, filed Apr. 25, 2007, now U.S. Pat. No. 8,108,914, whichclaims the benefit of and priority under 35 U.S.C. § 119(e) to U.S.Patent Application No. 60/794,529, filed Apr. 25, 2006, entitled“Emergency Responder Security System,” each of which, including theAppendix of the Ser. No. 11/740,063 application, are incorporated hereinby reference in their entirety.

BACKGROUND Field of the Invention

Exemplary aspects of this invention relate to security. More specificaspects of the invention relate to security management, a hierarchicalsecurity platform, converged IT and physical security management,unified credentialing, credential issuance and incident(s)/eventmanagement.

SUMMARY

The exemplary systems discussed herein are in general directed towardsecurity and security management. An exemplary aspect of the inventionrelates to physical security management and informationtechnology/network security management. Additional aspects of theinvention relate to a credential issuance and integrity checking systemsas well as associated readers and printers of the credential certificateand electronic personalization. Still further aspects of the inventionrelate to obtaining, assembling and analyzing one or more of data, videoinformation, image information, biometric information, sensorinformation, alarm information, perimeter information, terroristinformation, profile information, and/or other types of information toprovide a comprehensive platform for all aspects of security management.Still further aspects of the invention relate to providing a scalabletoolkit that allows complete management, integration, interoperabilityand centralized control and monitoring of all aspects of securityincluding personnel credentialing, personnel management, personneltracking, task management, equipment management, personnel tracking,security system integration and security information exchange.

The exemplary IT/network and physical security management system can bearchitected for open standards and its operability designed formodularity and scalability, and can be extendable across a spectrum ofsecurity needs, and adaptable to both legacy and upcoming technologies.The exemplary IT/network and physical security management system canalso be networked with other IT/network and physical security managementsystem(s) to allow for widespread security management, for example,during one or more non-collocated incidents, that may be one or more ofinternational, federal, tribal, state, city or local in nature.

Supporting multi-function contact and contactless smart card/token/smartchip/embedded/implanted chip user validation, the exemplary system workswith existing collocated and distributed facility environments, andoptionally supports various technologies including fingerprintrecognition, facial recognition, iris scanning, biometrics, geographicinformation system information feeds, and the like. Blending, forexample, video surveillance and hazardous environmental sensors, theexemplary system can be adapted to interface with building controlsystems, alarm systems, existing card readers, annunciators, cameras andvideo cameras, enterprise IT security systems, enterprise hardwired orwireless security systems, alarm systems, and general any securitysystem. The exemplary system allows integration into even the mostcomplex mission-critical enterprise IT security infrastructures through,for example, standard protocols, resulting in improved situationalawareness, ability to correlate events and control responses inreal-time, reduced administration overhead an improved audit andforensic capabilities.

The IT/network and physical security management system cooperates withthe Incident Management Parameter Access Control and Tracking (IMPACT)family of solutions which provide access control and identity managementfor deployment by, for example, one or more of Federal, State, local andtribal governments. The IMPACT family of solutions can cooperate withIT/network and physical security management systems to allow control ofphysical and IT access using, for example, a unified credential. Thesystem enables, for example, incident command to have a reliable,real-time emergency management hub that brings together all the assetsand resources into a field environment, including, for example,personnel management and tracking, video surveillance and hazardousenvironment sensors, wireless communications and backend communicationsto Federal, State and/or regional resources. Various card issuance andreading systems are also supported as well as manufacturers ofmulti-technology smart cards, such as contact or contact-less smartcards, smart chips and embedded/implanted chips. The IMPACT family ofsolutions can be configured, for example, based on the type of incidentor environment into which it is deployed. For example, the criticalinfrastructure elements discussed herein can each have a specific IMPACTsolution that includes specific modules, interfaces, templates,workflows and processes or sub-processes pre-configured for deployment.

The exemplary system supports both a multi-function contact andcontactless smart card/token/smart chip/embedded chip/implanted chip,user validation, and also works with a variety of incident scenarios andclimatic environments.

The exemplary system supports both a multi-function contact andcontactless smart chip user validation, and also works with a variety ofincident scenarios and climatic environments.

The exemplary system supports both a multi-function contact andcontactless embedded/implanted chip user validation, and also works witha variety of incident scenarios and climatic environments.

As examples, the systems described herein can be used for HSPDcompliance, such as HSPD 5, HSPD 7 and HSPD 12. There is a number ofcritical infrastructure and key resource (CI/KR) sectors in which thesystems described herein can be used, or defined to address any of theareas covered under these guidelines.

Exemplary non-limiting environments include: chemical, drinking waterand wastewater treatment systems, energy (power facilities, electricalgrid, oil & gas), dams, commercial nuclear reactors, water sectors,process manufacturing, emergency services, public health and healthcare,continuity of government, government facilities, defense facilities,defense industrial base, information technology, telecommunications,converged facilities, national monuments and icons, postal and shipping,banking and finance, commercial facilities, materials and waste,transportation systems, port security, aviation security, cargo, cruiseships, trains, mass transit, Intermodal, food and agriculture, military,first responders, police, fire and OSHA Compliance (Authentication &tracking of machine use). However, in general the systems disclosedherein can be implemented in any environment(s).

As an example, in a national/city based incident, an ID is used toderive access to all City/National Resources, and can include all HSPD7, and more. For example, access can be provided to water, power,facilities, transportation, city buildings and the like. In thisexample, the 4th factor of authentication which is Location Based intime/Global/ZULU/GMT can be supported. Additionally, a GUID and/or aUUID which is a universal or Global unique Identifier can also usecertificates including but not limited to PKI, PKCS #, etc. GUIDs, UUIDsand Certificates can be used in varying ways as any one item can defineidentity. Use can be cumulative, stand alone or a process can select thepreferred method for identity processes. Chip/card/Implant has sectorsthat only allow Authorized Writer/Readers/Users to allow for Multi-useand Multi-Administrators. Built in Fail-safe options include a runningagent that identified debuggers, heap readers, dis-assemblers and otherreverse engineering processes on the fly. Applications can then be shutdown into its stored encrypted state. In case of additional tampering,after a certain threshold of code has been tampered with, ArtificialIntelligence (AI) processes rewrite the code back to the original codebase (last known good configuration) and/or after so much loss can sealin encrypted container so only, for example, an authorized factoryrepresentative can reopen and/or it is destroyed. In addition, thesoftware and hardware case can be configured to scramble drive contentsupon compromise. This is useful in cases where classified data may siton a device.

Optional configurations include BOOT Choice on start-up to include butnot limited to evacuation conditions and/or Bomb scenario and/orIngress/egress of any area, an Artificial Intelligent system, a selfhealing network and systems component, Attendance and HR, the embeddedChip could be in Body and/or hand and have multiple administrators foruse in a single ID, multi-use and multi-administrators, (i.e., where achip/card has sectors that only allow authorized writers/readers/usersto allow multi-use and multi-administrators to access or update specificpartitions/sectors) HSPD 7 and other applications and all criticalinfrastructures, and any and all additions now and in the future,sensors in the ceiling and/or roof area in cooperation with GPS andother backend systems can track live movement of an individual and/orasset thru space and time, perimeter technologies can include but notlimited to, line of sight, satellite, fiber drop wire, radar, microwave,seismic sensor, beams, etc. . . . . Perimeter technologies can beapplied in a variety of environments to support very specific perimetercontrol requirements. All data and confidential information can beencrypted at rest and/or in transit—one exemplary way of encrypting thereader to the security system is by using encrypt and/or decrypt chipsas an I/O board attached to the reader and/or the security system.

Cooperation between the exemplary IMPACT family of solutions and theIT/network and physical security management system allows interfacedesigns to be built as modules that can be used as a checklist tocompile to produce any security product to address all CriticalInfrastructures and/or any other security systems, force protection,border control and/or need. These, as discussed, at least include thefollowing modules: sensor modules—including but not limited to chemical,hazardous, environmental, temperature, HVAC, physical SecurityModules—including but not limited to glass break, motion detection,physical access control, magnetic stripe, fire Suppression, etc.Converged physical and IT security access control is built into one ormore of the described systems can include communicationsmodule—including but not limited to, 900 mhz, 2.4 mhz, satellite,microwave, 800 MHz, HAM radio, 802.11, Fiber Optic, VOIP, CDMA, GPRS,etc. They also include the identity management aspects of the inventionand the mapping module including—static, internet based, real-timeimagery, data based and others, the cameras module, the behavioralanalysis modules, the audio and audio analysis modules, the EMS modulesand the alerting and logging modules.

The security system is an application that converges logical andphysical security into a unified process for access control of physicalentities and network or other logical entities.

Exemplary Components that allow this converged design are:

1. Client software provides an interface to an Active Directorystructure or an identity management structure (also includes FederatedIdentity Management schema), LDAP (Light Directory Access Protocol), andother schemas for identity information including InfoCard, the physicalaccess control structure and allows for configurations of securityzones, access permissions, camera operations, alerting, logging andother processes that support physical and logical access control.2. Remote controller is the domain controller containing the primaryactive directory structure and the controlling operating system.3. Physical access controllers are devices that provide reader controlfor physical access.

4. Cameras.

5. Logical control readers that allow for network or systemauthentication.6. SQL relational database or object-oriented, or object-relationalrepository that stores access information, user information, physicalinformation, zone maps and other information related to logical andphysical access control.The security system uses active directory, SQL and controller based datastructures to control physical and logical access. The elements are tiedtogether through processes that integrate active directory, a relationaldatabase backend and physical controller data structures. Clients thatprovide for disconnected Access control may also use ADAM (a clientizedversion of active directory) that may synchronize to a master activedirectory structure.

Access control is based on defining identities or grouping identitiesbased on Roles and then assigning them to security zones, networkedbased or system based objects. An object can be a file or other elementstored in a file system, database etc. . . . . An identity is defined bycreating a new identity and setting different configuration options thatrelate to networks, systems and or physical access control to includehours of access, security zones, accessible domains etc. . . . . Logicalattributes are stored within the active directory structure whilephysical attributes are stored within the controller data structure andother attributes that bridge both are stored in the relational datastructure. Services tie all three together in a transactional processthat guarantees identity update parameters (adding or provisioning,modifying privileges, and termination or revocation). Identities aretracked through the use of GUIDs, UUIDs and or certificates. Thisstructure allows for the best data integrity and reliability as well asmaintaining separation of duties between physical controllers andlogical controllers.

When the security system is installed the device identifies thecontrolling aspects of the logical networks and takes the role as themaster controller. Identity updates will occur to the device throughactive directory and active directory extensions. The other controllerthen act as authentication controllers for the network. CRITSEC alsoconducts a search and discovers physical control devices, systems andlogical network elements and takes control of those as well. Updatesthat are applied to an identity are transacted through a service thatacts as a broker between active directory, the physical controller andthe relational database.

The relational structure is implemented in a way that provides for datamapping as opposed to hard defined data structures. This allows user ofthe CRITSEC system to use a variety of data backends to use CRITSEC withto include MS SQL, Oracle, MySQL and other.

Supervisory Control And Data Acquisition (SCADA) is a remote controlprocess that controls infrastructure such as water or power etc. . . .There's a client that communicates with a control device that controlssome aspect of a process. The exemplary componentry associated with theSCADA embodiment includes: Client software that provides an interface toa variety of controllers. SCADA software secures SCADA operationalprocesses through an enhanced SCADA interface. Controllers and remoteterminal units are, for example, devices that monitor and open or shutvalves or perform some other function that is required to maintaincertain process attributes. A controlled device is, for example, a valveor other device that has impact over a controlled process. The securitysystem integrates logical and physical access control to SCADA networks.SCADA has been over the years inherently weak when it comes to accesscontrols and security. SCADA security addresses this by integrating theSCADA network with the security system for controlling physical andlogical access to SCADA networks. SCADA security also provides for amore secure interface while allowing SCADA operators to continuallymonitor processes through a locked for input but functional, visibleopen to monitoring screen. Physical and logical access controls aresimilar to the other applications and processes described herein. Theclient software secures the SCADA management process by creating atransparent screen that SCADA operators can use to monitor SCADAprocesses. Though users can see processes in real-time, they can'tinteract with the process until authentication takes place through thesecurity management system. Once authentication takes place then thetransparent screen moves to a background process while the SCADA clientapplication takes the foreground process and allows for operatorinteraction. Alerting takes place through a colored border that flashesat the edge of the border of the screen, still allowing the operator tomonitor real-time actions through the transparent screen.

These and other features and advantages of this invention are describedin, or are apparent from, the following detailed description of theexemplary embodiments.

BRIEF DESCRIPTION OF THE DRAWINGS

The exemplary embodiments of the invention will be described in detail,with reference to the following figures wherein:

FIG. 1 is an overview of the exemplary security system according to thisinvention.

FIG. 2 illustrates exemplary components that can be associated with acredential according to this invention.

FIG. 3 illustrates an exemplary credential issuance system according tothis invention.

FIG. 4 illustrates in greater detail the components of the IT/Networkand Physical Security Management system according to this invention.

FIG. 5 illustrates in greater detail the IMPACT system according to thisinvention.

FIGS. 6-37 illustrate exemplary graphical user interfaces associatedwith this invention.

FIG. 38 illustrates an exemplary relational database structure accordingto this invention.

FIG. 39 illustrates exemplary data flow processes according to thisinvention.

FIG. 40 illustrates an exemplary credential shield according to thisinvention.

DETAILED DESCRIPTION

The exemplary embodiments of this invention will be described inrelation to security management. However, it should be appreciated, thatin general, the systems and methods of this invention will work equallywell for any type of communication system in any environment.

The exemplary systems and methods of this invention will also bedescribed in relation to security management and the components,sensors, hardware, software and data feeds associated therewith.However, to avoid unnecessarily obscuring the present invention, thefollowing description omits well-known structures and devices that maybe shown in block diagram form or otherwise summarized.

For purposes of explanation, numerous details are set forth in order toprovide a thorough understanding of the present invention. It should beappreciated however that the present invention may be practiced in avariety of ways beyond the specific details set forth herein.

Furthermore, while the exemplary embodiments illustrated herein show thevarious components of the system collocated, it is to be appreciatedthat the various components of the system can be located at distantportions of a distributed network, such as a telecommunications networkand/or the Internet, or within a dedicated secure, unsecured and/orencrypted system. Thus, it should be appreciated that the components ofthe system can be combined into one or more devices, or collocated on aparticular node of a distributed network, such as a telecommunicationsnetwork. As will be appreciated from the following description, and forreasons of computational efficiency, the components of the system can bearranged at any location within a distributed network without affectingthe operation of the system. For example, the various components andfunctions associated therewith can be divided between one or more of thedescribed systems, can be load balanced between one or more securitysystems and can be networked between on or more security systems,devices, or some combination thereof. Similarly, one or more functionalportions of the system could be distributed between a plurality ofgeographically separate systems.

Furthermore, it should be appreciated that the various links, includingany communications channels connecting the elements can be wired orwireless links, (including satellite based link(s) or any combinationthereof, or any other known or later developed element(s) that iscapable of supplying and/or communicating data to and from the connectedelements. The term module as used herein can refer to any known or laterdeveloped hardware, software, firmware, or combination thereof that iscapable of performing the functionality associated with that element.The terms determine, calculate and compute, and variations thereof, asused herein are used interchangeably and include any type ofmethodology, process, mathematical operation or technique. It shouldalso be appreciated that various levels of redundancy and portabilitycan be included with the system, as well as a shock mount case foremergency drops to remote locations, such as battery back-up,multi-national power supplies, recharging capabilities, and a pluralityof communication options.

FIG. 1 illustrates an exemplary security system 1. The security systemincludes an IT/Network and Physical Security management System 100, anIncident Management Perimeter Access Control and Tracking module 200 anda credential issuance system 300. The IT/Network and Physical Securitymanagement System 100 can be connected, via one or more of network 10and links 5, to one or more additional IT/Network and Physical SecurityManagement Systems as well as an identity proofing module 11, one ormore sensors 12, a unified credential 13, one or more access controlreaders 14 (which can govern physical as well as network/computeraccess), one or more cameras and/or video cameras or feeds 15, existingenterprise IT security system(s) 16, existing enterprise securitysystems 17, such as building access systems and alarm systems 18 andassociated annunciators 19 and devices.

FIG. 2 illustrates an exemplary credential 200, and some of the types ofinformation and information carrying devices associated therewith. Forexample, the credential can include one or more of a contact-based chip,embedded chip(s), implanted chip(s), bar code(s), printed data,picture(s), a proximity chip, a magnetic stripe and a contactless chip.Each of the information carrying devices have certain associatedadvantages and disadvantages and can be chosen, for example, based onthe expected operating environment, environmental conditions, data to bestored thereon, security requirements and the like. The credential canbe any one or more of a smart card, smart chip and embedded chip. Thesecurity system can automatically recognize the card type, issuingagency, format, etc., as well as what authorized information can beread. This allows for multi-administrators, multi-use, multi-readers andmulti-sections (with each section have different access permissions),i.e., an e-passport.

While certain embodiments are described in relation to the exemplarycredential, other options are also available. For example, although auniform visual card design is desirable, experience indicates that whilethe flash-pass capabilities are important, more crucial is theuniformity of the information programmed into the smart card/smartchip/embedded/implanted chip. The credential issuance system canabstract the desired data into containers or sectors of the credentialthat are programmed into the smart card chip, some with varying degreesof protection for very sensitive data like biometric templates. Thesecredentials/certificates are thus immediately usable at the incidentsite(s), not within some delayed time period, such as 24 hours.Revocation can also be immediate. Interoperability with otherstandards-based cards can be a key architecture principle.

While a standard template can be defined, other templates may be added.For example, while one jurisdiction may choose to store encryptedfingerprint, iris scan, hand geometry or facial recognition, includingany biometric, in an encrypted card container, another jurisdiction mayutilize the same space on the card for emergency medical treatmentinformation. The ability of the credential issuance system to discernthe differences between the two card types described is a unique featurethat can be enabled as required. Thus, different entities can havedifferent permissions to access different portions of one or morecontainers or sectors of the same card. Highlights of an exemplarycredential include:

Data Capture and issuance Optional Version for Contact Chip Works withthe Credential Issuance System for Printing/ Lamination—Enables ‘OneButton’ Print/Program Works with IMPACT and the IT/Network and PhysicalSecurity Management System for Contactless 13.56 MHz Chip and otherembedded/implanted chips Authorization & Tracking Unique Identifier byIndividual Global Unique Identifier (GUID) or Optional Cardholder UniqueIdentifier (CHUID) Digital Certificate Follows PKCS11 Standard—and allfuture standards, technologies or certificates as them become availableLifecycle Operations Secure Identity Management System (IdMS) SecureContainers for Data on Chip Works with IMPACT and the IT/Network andPhysical Security Management System Reprogram or Update Data in Field orCentrally Real-time Validation of Digital Certificate Verificationthrough, for example, a third-party Rapid Provisioning and Terminationof Privileges—NOT 24 hours Maintain High ‘Level of Trust’ Manage Data onCard, in IdMS or both • Portable and Fixed Base • Modular • SecurePre-Issue Multi-function Credential or Onsite Verify Identity VerifyAuthorizations Ensure ‘Level of Trust’ Create Photo ID or Smart CardBadge for this Incident Update Smart Card Chip if 2nd Incident VisualGrouping by Skill or Responsibility Utilize for Physical and LogicalAccess Stored X.509 or PKCS11 Certificates—and all future certificatesas they become available Match-on-Card Biometrics Smart Card/SmartChip/Embedded Chip and use of SQL and the and active directory RegistrarFunctionality Sponsors Submit Applicant's Background Check InfoRegistrar Collects Identity Information In-Person Fingerprints and I-9Documents System Tracks Status of Application Notification When NACIComplete ID Management System Active Directory Link Revalidation Dates,Moves, Adds, Changes, Terminations Distribution of Applications PINResets Robust Member Search and Auditing Capability SQL or SQL LinkFile/Data transfers

Write IMPACT is an application that allows for the reading and writingof contact and contactless smart cards.

Exemplary Components:

1. Client software that allows for writing and reading data, acquiringbiometric data and specifying certifications.2. Data backend for storing data in either a connected or disconnectedstate.3. Interfacing for smartcards.Write Impact has the capability to write and read contact/contactlesssmartcards that meet a variety of standards to include HSPD-12, Mifare,Desfire, Smart MX and others.

Due to card storage size and end user requirements, a matrixing solutionhas been developed that allows users to add a large amount of data intolimited space on the smartcard chip. The matrix allows for defining amapping solution from the application to the card's database andvice-versa. This allows agencies to define their own data and enter itinto the chip of a card while not using the space required to enter thatdata. An example would be: Denver Sheriff Department wants to trackcertain certifications that they have developed. The exemplarycertification is broken down to a 3 or 4 (or in general any) digitnumber or lettering scheme that designates that the certification islocal, that the certification is related to law enforcement, that thecertification is for SWAT and that the final certification is for level.There is also a 1 digit number that specifies if the user is current,not current, in retraining, or that currency doesn't apply. This schemaallows for the storage of much more data on a chip that can be directlyreferenced through the back end. Other agencies may then map their datain their own way and agency data may be correlated together through amapping structure so outside agencies have visibility of certifications.

For protecting the credential, as illustrated in FIG. 40, a shieldingcredential holder device leverages a magnet to hold a clear cover to ashielding back, and can be flipped out with one hand when one needs toenable the contactless signal when presented to a reader to, forexample, open a door. Credential holders that shield contactlessemanation from unwanted and/or unauthorized reading are currentstate-of-the-art, however convenient usage by an individual whenentering a secured facility is somewhat lacking. The illustrated unitsare designed to feature a clear pocket for the credential thatmagnetically adheres to a shielding backing. Thus, a user is able toconfidently display the front of the credential on a lanyard or clippedto clothing knowing that it cannot be read contactlessly in this mode,yet easily separate the clear pocket from the backing with one hand toexpose the contactless signal when required, and allow reading thereof.

FIG. 3 illustrates an exemplary credential issuance system 300. Thecredential issuance system 300 comprises a signature capturer 305, a PINkeypad capturer 310, a fingerprint capturer 320, a camera 330, a modulefor registrar functionality 340, an ID management module 350, a reportprinter 360, a card printer 370, a card reader/writer 380, and adocument scanner 390, all interconnected via one or more links andnetworks. One or more pieces of data can be secured via the appropriatecapturer and associated with a credential. The data can be associated,in cooperation with the card reader/writer 380, by storing informationon the card or printing information on the card. This information, or aportion thereof, can also be encrypted as needed.

The credential issuance system 300 also can cooperate with a module forregistrar functionality. Registrar functionality can include abackground check, fingerprinting and I-9 documentation, system trackingof the application process and notification of when the NACI iscomplete. The ID Management module can include an active directory link,revalidation functions, date and tracking, moves, adds, changes,terminations, and the like, for an issued credential. The ID managementmodule 350 can also handle the distribution of applications, PIN Resets,robust member searching functionality and auditing.

FIG. 4 illustrates the IT/Network and Physical Security ManagementSystem 100 in greater detail. In particular, the IT/Network and PhysicalSecurity management System 100 comprises one or more of a data store105, logging module 110, authentication processes/access control module115, data filtering module 120, data marts/warehouses 125, ArtificialIntelligence modules 130, video module 135, document module 140, mappingmodule 145, training/prediction reporting module 150, sensor module 155,audio module 160, VOIP module 165, communications management module 170,user module 175, admin module 180, environment specific module 185,information feed module 190, scalability and interconnection module 195and security module 199, all intercommoned via the appropriate link(s)and/or network(s) as required (not shown).

FIG. 5 illustrates in greater detail an exemplary member of the IMPACTfamily of solutions 200. In particular, the IMPACT system comprises oneor more of an equipment tracking module 205, a personnel tracking module210, a perimeter management module 215, a credential management module220, a task module 225, an alert module 230, a reporting module 235 anda sensor module 240, all intercommoned via the appropriate link(s)and/or network(s) as required (not shown).

In operation, an administrator initializes the system by adding thepersonnel, equipment, credentials, or in general any tangible orintangible, that are to be managed. The addition of the managedinformation can be streamlined through the use of one or more templatesdesigned for specific incidents and/or environments. For example, whenbooting the security system, the system can query the user as to thetype of deployment, incident or environment. Based on the user'sselection, specific GUI's, templates and prompts for connections tovarious types of data feeds can be generated. Once all relevantinformation pertaining to the managed information is established,various pre-defined rule sets can be invoked or one or more custom rulescreated that allow actions to be triggered based on satisfaction of oneor more rules. For example, if the incident is a fire and the securitysystem is connected to the existing building fire system, a pre-defined“building fire” rule set could be selected that allows the securitysystem to monitor heat sensors, movement of emergency responders in thebuilding, fire sensors, video feeds, etc.

In addition, the security system can monitor the presence of emergencyresponders into and out of the incident scene. This not only allows tothe system to account for the presence and location of personnel, butalso more routine tasks such as billing management. In the event of aninjured emergency responder, the system could also automatically forwardmedical information based on the emergency responder's credential to ahospital to assist with treatment.

The IMPACT family of solutions can also be preconfigured withconnectivity escalation routines that allow the security system tocontact one or more additional security system based on, for example,the meeting of one or metrics monitored by the system. For example, ifexplosives or an explosion is detected, the security system and forwardinformation related thereto to the federal authorities. Additionally,the security system may connect to other security systems to assist inthe analysis of trend data in the event of, for example, widespreadterrorist activity.

In another exemplary embodiment, the system is not actually deployed toan incident, but is used as a full-time security monitor for one or moreof a facility/network/computer system. The system can also interfacewith existing structures, such as a school, utilizing the appropriatemodules, allowing control over and monitoring of, for example, a schoolssecurity system. For example, the security system can be connected wiredor wirelessly by an emergency response team to the school and controlall aspects of security including cameras, locks, access, etc.

FIGS. 6-37 illustrate exemplary GUI's associated with the securitysystem. With all the exemplary GUI's different skins can be selectedthat are suitable for different lighting environments, thus allowing theapplication to be easily seen inside or outside, while it is bright ordark, in red, blue, green, yellow, white light, etc. In particular, FIG.6 illustrates an exemplary access control GUI where a user would go toadd other users, permit what they can do have access to (i.e., logicaland/or physical), and the hours and zones they have access to theseresources. Other things can be controlled here such as the person'scertifications and username and password. The Connected Tab (locatedabove the Full Name) shows a list of all the different users that arecurrently connected to the system.

The Reader button (located bellow the Time Zone) will group the cardreaders into logical groups that will be considered one of many zones.The Users button gives you a list of all the users that have been addedinto the Access Control for quick navigation to a specific user.

FIG. 7 illustrates an exemplary main navigation menu. The mainnavigation menu allows a user to move through the application. It can bemoved as well as set to auto hide in case you need more screen space forthe content area. The main area in the content area. All the toolsselected from the main menu can be illustrated in this main portion.Tabs or buttons are also provided in this interface to access otherfeatures of the system. In this example, the tabs are “org chart,”“packages,” etc. The lower portion of the GUI is the log. The logillustrates all the events that have happened such as a connection tothe server. Like the main menu, this can be moved, resized, or set toauto hide, and each event in the log can be selected for additionalinformation.

FIG. 8 illustrates an exemplary custom time view GUI where a user cancreate custom times that a user is allowed into either physical or thenetwork. Times can be set from any day of the week and can be controlleddown to the hour.

FIG. 9 illustrates an exemplary incident GUI. The Incident screen givesa quick overview of the scene that includes who opened it, the date itwas opened and closed, and location. Additionally, historical data canbe shown so lessons learned from one event can assist in the decisionmaking process.

FIG. 10 illustrates an exemplary Org Chart (Organization Chart) that canbe used to see a graphical representation of the incident commandstructure under, for example, a HSPD. By simply dragging and dropping, asingle person or an entire group can be placed under a differentcommander. A user can add or remove any of the nodes for situations thatrequire different specialists. A user can also fill the role of thepositions with people that have been added to the Access Control area.

Expand and Collapse button controls all the boxes and expands all ofthem, or collapses all of them.

FIG. 11 illustrates in greater detail some of the Org Chart information.

FIG. 12 illustrates an exemplary SITREPS (Situation Reports) GUI. Thesituation reports can be updated every time something is changed in, forexample, an emergency scene, event or exercise.

FIGS. 13 and 14 illustrate lists all of the different agencies that areat the scene. Within each agency is a list of all the employees. Eachemployee has information about them such as status (deployed, staging,etc.), blood type, and cost rate. Then each employee will have a list ofcertifications that they carry. Information held here pertains to whendid the individual receive the certification, when does it expire, whenis he expected to have it renewed, and if the person has insurance.

FIG. 15 illustrates the different packages and their status, includingwhen they arrived at the emergency scene.

FIG. 16 illustrates an exemplary tasking screen, a user can assignvarious tasks that can include a description, when it was assigned, whenit needs to be completed by, who it is assigned to, priority, and it'ssensitivity. Tasks can be assigned to an individual or to agroup/agency.

FIG. 17 illustrates an auto populated log that provides a brief overviewof everything that has occurred within this incident including when anew Incident Commander comes in, when new SITREPS are created, and whenpackages arrive.

FIG. 18 illustrates the History Tab showing a brief overview of all theincidents for quick reference. When a user selects one of the incidents,that incidents information is seen through the rest of the EMS tabs.This is used for not only review, but if an incident is happening thatis similar to a past scene, it can provide for a quick way of seeingsome of the possibilities that could happen.

FIG. 19 illustrates an exemplary video GUI. The video GUI at leastsupports IP, USB, and CCTV and wireless cameras with support for audio.The video GUI can auto adjust if more than four cameras are added andthe ability to manually resize each box. Snapshots and recording can beautomated through rules, so if someone tries to swipe a card that isinvalid, you can automatically take a snapshot capturing the personsface. Motion detection can be used for the entire camera view or you canset up grids so that it will only record if there is motion within thatarea. Frame rate can also be controlled from here.

FIG. 20 illustrates an exemplary sensor GUI. The sensor GUI displaysdata from a sensor that can be captured and displayed as a 2D/3D graphor mapped into a GIS. A user is also able to turn on and off the variousbars as well as the markers. A user can also change a bars color, width,as well as the amount of time that they are viewing in the recordeddata.

FIGS. 21 and 22 illustrate the ability to open a wide variety of variousdocuments, including the ability to utilize a built in spell checker andthesaurus. Also supported is a built in capability to open variousspreadsheets. This is where a user can come to open template-type formsthat can be blank or pre-populated with data from the incident.

FIGS. 23-25 illustrate various scheduling interfaces. Here a user cansee a daily over view of different tasks that have been scheduled. Auser can delete/add new columns by clicking Delete/Add buttons on theright. A user can add a new task into a timeslot by double clicking thetime that you want it to start. When a user adds an event to the timeslot, it can be titled, given a location, mark what type of an event itis, show its status at that time (i.e. busy), and set a duration. A usercan also set up a reassurance so this event is automatically theredaily, weekly, biweekly, monthly, annually.

FIGS. 26-27 illustrate alternative scheduling GUI's. By changing theview to a weekly view, a monthly view, or an annual view, a user caneasily see all of the appointments or scheduled events and historicaldata.

FIGS. 28-31 illustrate exemplary mapping GUIs. A user can use bothstatic mapping or Internet mapping and can tilt, rotate, and zoom inthrough the tools on the right. A user can also bring in various layers,even to the Internet mapping that can provide different information.Terrorist alerts/maps, disasters maps and GIS data, as well as existingterra maps and GIS systems can also be obtained by the system.

FIG. 32 illustrates a built in VOIP GUI and chat support that allows forcommunications as long as there is power. A user can also record VOIPconversations in this GUI.

FIG. 33 illustrates an exemplary metrics GUI. Here a user can total autilization cost, as an agency, and even by there status. This can bedone, for example, for Agencies and Resources. This allows, for example,states/counties to call for federal assistance as soon as it isavailable or limits are reached.

FIGS. 34-37 illustrate various exemplary admin GUIs. Within the AdminConsole, a user can check out the server's health status, have itautomatically send alerts to E-Mail, a phone, a computer, or just writea log. Within the console, a user can set up automatic discovery and/orfailover with other security systems, or the systems can be manuallydiscovered. The software can also be configured to automatically checkfor updates from this console.

FIG. 38 illustrates a high-level architecture of a relational databasethat can be used in conjunction with the embodiments described herein.The attached Appendix provides more detailed specifics regarding thearchitecture and the relationships therebetween, with the numbers in theconnecting lines corresponding to the relationships detailed in theAppendix. In general however, any relational database, object-orientedor object-relational database structure will work well with the systemsand methods of this invention provided a mapping between associatedelements can be determined. This exemplary architecture represents therelationships between, for example, video, graph, audio, VOIP,documents, equipment, personnel, tasks, etc. . . .

FIG. 39 illustrates an exemplary data flow and process tree according toan embodiment of this invention. The exemplary processes depicted withinthe figure illustrate connectivity and process flow. These flow diagramscan be consistent throughout all various modules. For example, both theIMPACT family of solutions and the IT/Network and Physical SecurityManagement System can include the same processes for cameras, video,access control, etc., as well as a Supervisory Control And DataAcquisition (SCADA) type system using the functionality describedherein, with all of the systems capable of including the same processesas other modules and process applied to data operations, etc. The scopeof all modules can be configured into a self-healing networked structurewhere if a piece, segment or network were to fail, a self-healingprocess could instantiate itself and rebuild critical parts of anyportion of the system(s) and/or network. The systems/networks can alsosupport a failsafe mechanism that allows for the destruction of a deviceif, for example, tampering is detected.

The exemplary processes that can b performed by one or more of themodules discussed herein (or by one or more modules connected to thesecurity management system) are: New Record, Replication Process, VideoProcesses, EMS Processes, Mapping Processes, AuthenticationProcesses/Access Control, Document Processes, Logging Processes, SensorProcesses, Support Processes. Audio Processes, VOIP Processes, AIProcesses, Data Scrubbing, Data Scrubbing, Trending/Prediction ReportingProcess and Communications Processes.

The New Record process allows the creation of a new record. This newrecord can relate to personnel, equipment, monitors, sensors,credentials, or in general any aspect of security management includingboth tangible objects/personnel and intangibles.

The Replication Process allows both upstream and downstream replicationof information. This replication can include filtering to allow for ahierarchy of data flow with, for example, permissions established suchthat data stores with lesser permissions have access only to certainportions of data.

The Video Processes, as with the other types of “data” feeds, such asaudio, VOIP, etc., are logged in a logging module and preserved in alocal data store as well as monitored by the AuthenticationProcesses/Access Control Process. Video can be also be streamed fromdifferent devices using different transmission protocols to include IPbased, BNC, Web and others.

The EMS Processes is one of several exemplary processes that reflect thevarious operating environment(s) into which the systems and methodsdescribed herein may be placed. It should be appreciated however thatthese specific operating environment type processes can be combined withother operating environment type processes as needed and may bedynamically added at any time. For example, during boot of theIT/Network and Physical Security Management System, the environment canbe configured through selection of the specific event type(s). EMSprocesses cover all aspects of an incident to at least includepersonnel, equipment, org charts, situation reports, lessons learned,scheduling, mapping, and other related items specific to an event.

The Mapping Processes allows the integration and display of map(s) intothe Network and Physical Security Management System. The MappingProcesses at least includes one or more of GIS, real-time mapping,static mapping, overlaying mapping with various sets of data eitherretrieved, input or correlated through AI Processes onto maps that canbe made available to a user(s).

The Authentication Processes/Access Control Authentication includeslogical and physical authentication through, for example, various chipprocesses to include contact and contactless chips as well as biometricsthat may be attached, imbedded embedded and/or implanted anywhere in thebody including the hand and head. Authentication mechanisms also providefor the tracking of incrementing and decrementing values as well asstorage of finite values within the authentication medium if anon-biogenic authentication template, e.g., smartcard, is used.Identities can be tracked and authenticated through, for example, GUID,UUID, certificate based processes, or in general any mechanism, locally,regionally, nationally and internationally. The authentication mediumwill also allow for in some cases multi-user/multi-administrationcapabilities. Authentication at both physical and logical layers caninclude encryption using standard approved methodologies as well asfuture encryption strategies utilizing, for example, nano-technologiesor quantum technologies not only from the controller to the controllingdevice (door reader for example), but also from the controlling deviceto the controller and/or other operating system that may act as anintermediary or controller itself. The Authentication Processes allowfor multi-factored authentication mechanisms to include, for example,what someone knows, what someone has, who someone is, where a person is,through space and time, through behavioral analysis as well as othermechanisms. This will allow for authentication of identities, groups,processes, etc., as well as physical devices and information sources.

The Document Processes allows for the creation, viewing and modificationof secured documents through a data labeling process, as well as themanagement and classification of documents. For example, an AI processclassifies documents on the fly based on, for example, certain keywords,origin information, creator information, content, or phrasings as wellas by the classification authority or creator. Documents identified assecure can be stored in an encrypted format within the database.

The Logging Processes support event correlation through a triage AIprocess for each entry added to the log. Logsets can be multi-recordstructures where event correlation takes place against a set of logentries that may or may not be similar in nature. Logs can be archived,for example, at the event level and can be fine tuned to, for example,periods of time.

The Sensor Processes not only include sensors for environmentalcharacteristics but also include tracking through thermal, biologic,pressure and other methods provided through a sensor interface.

The Support Processes include failover support, self-discovery and othersystem configurations. Support processes also include all processes thatprovide for systems administration, configuration, healing, alerting,balancing or other processes supporting any of the described processesor modules.

The Audio Processes allow for the modeling of various audiocharacteristics. This can include sound that is audible to the humanrange or outside the scope of human range.

The VOIP Processes allow VOIP communications over one or more networksto one or more other IMPACT and/or IT/Network and Physical SecurityManagement System(s). VOIP and Conferencing services allow for internalconferencing capabilities. The only requirement is connectivity throughany available means. Conferences can be recorded stored and verified inthe future.

The AI Processes include rule set, fact set, fuzzy and neural processesto predict and trend. Intelligent processes include inferencingtechnology, neural processes as well as other multi-generationintelligence processes. In terms of intelligent processing there arethree layers.

-   -   1. Triage (Real-time)—this is accomplished as raw data is        entered through a process. This basic yes/no type rule set logic        and can be applied to an individual record very quickly.    -   2. Near real-time—This can be accomplished across multiple        records as data sits in an active local data store. The        correlation of this data can be more complex than simple rule        sets and can include complex nested rule sets as well as facts        applied.    -   3. Historical—This takes place against a data mart/warehouse        and/or a regional, national and/or international level data        source. These AI Processes can include not only rule set and        facts, but fuzzy logic through inferencing and in some cases        neural networking, as appropriate.

AI Processes allow for human and non-human intervention, alerting andother modifications to configurations, data or other items designated asmodifiable on-the-fly. Expert Systems can attempt to emulate thedecision making abilities of a human expert using knowledge (facts) andinference procedures (rules). In some cases other intelligent processesmay be used such as neural networking, data clumping, associativediscovery etc. . . . . AI processes are designed to find events, trendsand predict where the data to support that data doesn't appear to exist.

The Data Scrubbing process allows for sanitizing of data by any means,such as rule based sanitizing.

The Trending/Prediction Reporting Process can cooperate with the AIProcesses to generate trending and/or prediction reporting and alertsbased on one or more of incident information, information feeds,activity, data trends or in general any information received by theIT/Network and Physical Security Management System.

The Communications Processes include any method for communications toinclude satellite, cellular, wireless, networked, encrypted, hardened,packet or circuit-switched, or any other communications process orprotocol.

The Data Stores house data that can be shared with one or more otherdata stores. The data stores can store any information relevant to theIMPACT and the IT/Network and Physical Security Management Systems, aswell as credential issuance system, and in general any informationassociated with the systems described herein.

In addition to the above higher-level processes, sub-process operatewithin the security system. A description of the exemplary sub-processesare discussed below.

The Record Management process allows entities identified with“administrator” privileges to administer records. These records includeidentity records and administrators can at least add, delete or modifyidentities as well as levels of permission, access control, etc., and ingeneral any feature associated with a record including the creation,modification or deletion of a record.

The Identity Configurations process includes all aspects of an identityaccount. These includes basic personal information such as name, DOB,position, access control parameters—to include access points and hours,biometric data etc. . . . . An identity is directly correlated to acertificate and a GUID/UUID or other unique identifier. These items areused to correlate identities to other sets of information throughlookups.

The Permissions Process provides and regulates permissions toinformation and/or objects.

The Access Control process provide for both logical and physical accesscontrol solutions to one or more physical areas and/or computer,computer network or IT-based systems.

The Authentication Process determines whether or not an entity has theauthority to access and manage records.

The Record Management Process includes the ability to add records,delete records, modify records as well as provides record navigation andsearching functionality.

The Active Directory Process provides standard active directorystructures and extended active directory structures. For example, in anemergency response scenario, the security system 1 is a self-containednetwork whereas in other incident management solutions active directorycan be integrated into an existing network structure. In cases where anincident management solution must control access logically, the securitysystem can act as the master controller and only make updates to theactive directory databases while, for example, dedicated, incidentspecific incident management controllers will act as authenticatingmechanisms thereby reducing the overall load on the IMPACT system.

The Physical Access Control Process controls, for example, disconnectedhand-held or other types of credential reading devices that can beupdated, for example, on-the-fly through wireless, wired or by removablemedia. The devices can first authenticate to one another prior to dataupdating. In other IMPACT scenario solutions, physical readercontrollers can be embedded into the IMPACT solution and controlphysical access by a direct or wireless connection to the terminalreader.

The Motion Detection Process allows for the configuration of thesensitivity of the detection grid in one or more connected video camerasor feeds as well as other options related to motion detection. Themotion detection processes can be defined to slew a camera to a certainposition if motion enabled cameras are used.

The Snapshot Process allows snapshotting by extracting a single framefrom a video stream. Snapshotted graphics can be stored in an encryptedformat and checksummed for evidentiary use.

The Streaming Process allows video to be streamed to a user interfacewithin the security system and can be saved in, for example, acompressed and encrypted format to the data store. Video can also bechecksummed for evidentiary use.

The Video Interface Process allows a user to manipulate and view videodata. This interface allows also acts as the record management interfacethat allows user to add, delete, modify and navigate video records, forexample, with the use of meta-data, keywords, etc.

The Does Mods Process allows video data stills and in some casesstreamed video data to be included into documents that are stored withinthe data store.

The Camera Control Processes allow camera controlling through motiondetection as well as user remote control of any of the camerasassociated with the security system.

The Logging Process can support event correlation through the triage ofartificial intelligence processes for each entry added to the log. Logsets can be multi-record structures where event correlation takes placeagainst a set of log entries that may or may not be similar in nature.Logs can be archived off at the event level and/or system level and befine tuned to periods of time.

The Event Data Process allows management of event data, comprising basicinformation pertaining to an event, to include, for example, incidentcommander, location, perimeters, zones and event descriptions.

The Situation Reporting Process allows situations taking place during anevent to be identified, flagged and tracked.

The Org Charting Process provides the ability to create and manage anorganizational chart of the incident staffing. Personnel can be selectedto fill slots within the organizational structure. Also when anindividual is selected to fill a role, the role can be cross-referencedwith certifications data that is tied to personnel. If, for example, theindividual is not certified to fill a role, then, for example, based onan active rule set, the incident commander can be informed. An incidentcommander can also be authorized to override the flag. There can be morethan one organizational chart per event.

The Personnel/Equipment/Certs Process allows one or more of personnel,equipment and personnel certifications to be tracked through an event toinclude, for example, cost rates, use, renewal information and otheritems.

The Package definition Process allows packages to be defined by standarddefinitions, non-standard definitions as well as task force definitions.Packages can be requested, offered for deployment and in specialcircumstances be defined on-the-fly during and at an incident. Packagesare normally defined and then pushed to, for example, a regional andnational data store for deployment. Packages can also be requested byvarious agencies to take part in an event.

The Historics Process allows for the management and creation of “lessonslearned documents” as well as documents generated through an artificialintelligence process that correlates useful information for specificrequirements during an incident. This gives event managers access todata and data mining capabilities that may uncover information relevantto the incident(s) such as trending information. Documents can becorrelated from local, regional, national and/or international sources.

The Graphic Layering process allows graphic overlay(s) to be added to ortaken off of a mapping structure. Layers can represent different sets ofinterpolated data.

The Internet Based Mapping Wrapper Process allows for including accessto internet based maps. This provides, for example, an instant mappinginterface that doesn't require any static map files to be carried withthe security system. Layers can be added to internet based mapping torepresent different sets of data.

The Data Interpolation Process allows taking data from differentsources, turning that data into coordinate data and then placing it intoa graphic layer to be presented through a mapping interface. Data canrepresent sensor locations, boundary locations, personnel locations,equipment locations, or in general data the security system has accessto.

The GIS Processing Process allows real-time GPS related navigation, aswell as other GIS related mapping processes. For Example, responders canuse GPS enabled tracking devices that can be represented in a mappingstructure. This is useful for deploying, tracking and recallingresponders that may be in hot, warm, cold or all zones, etc.

The Graphical Interface Process allows one or more graphic interfaces tobe used to manage records as well as provide for option selections and aviewing interface for the mapping modifications.

The Doc Generation Process allows user to create spreadsheets, wordprocessing documents, flowchart documents, graphic documents as well asother document types. These documents can be labeled with a securityclassification and then encrypted into the data stores where other userswith the proper classification can then view the documents. Thisprovides for a secured document access control system that providessecurity, integrity, reliability as well as the capability to controldocument dissemination.

The Classification Process allows classification labels to be added toany information within the system and can add a mandatory layer ofsecurity to document control that does not exist in discretionaryoperating systems that provide for shared access control. Each documentcan be labeled with a classification and clearance requirement that istied directly to the data object.

The Sensor Data Parsing Process allows data entering the security systemfrom any information feed, such as a sensor feed, to be parsed into datathat can be represented in a graph series. Parsing can be unique to thesensor type and manufacture. To effectively parse data themanufacturer's data schema can be processed and stored into aretrievable data structure that can be identified on-the-fly to thesensor.

The Sensor Chart Generation Process allows the representation of sensordata through a graph series. Each graph can hold multiple series andupdate in real-time based, for example, on parsed data.

The Sensor GUI Interface Process allows a sensor GUI to act as therecord management facility as well as the interface for sensor graphsthat can depict real-time sensor feeds for a variety of sensor types.

The Logging/Alerting Services Process are specific to applicationprocesses and specific server processes. To configure logging andalerting, administrators can select an event type and then apply a ruleto the event. Then, based, for example, on the relationship between ametric and the event, alarms triggered, actions activated, alerts sentto one or more individuals, entities or groups thereof, or the like.

The Identify Facts and Factsets Process allows processing of facts andfact sets that are known or defined facts about an expert domain.

The Build Rules and Rulesets Process allows for inferencing processes totake place.

The Apply Fuzzy Definitions Process allows for the application ofintelligence to address non-linear problems.

The Define Training Requirements Process allows for the training of oneor more neural networks.

The Stream Analysis Process allows for the capability to determinedirection and distance of sounds as well as the sound type. Audiostreams can be used as alerting features and can be saved in anencrypted format into a data store and checksummed to prove authenticityin the future.

The Audio GUI Process allows an audio GUI(s) to act as the recordmanagement facility as well as the graphic interface that allows usersto configure and process audio data. Audio data can be collected fromdifferent sources.

The VOIP/Video Conference process allows audio and/or videocommunications between connected security systems. A specific securitysystem can itself act as a collector for conversations from other endpoints. The security system can then trunk the communications into astream of data that can be sent out to one or more participants.

The Reporting Process allows generation of different types of reports.

Ad Hoc—Ad Hoc reports show the user exactly what is on screen in thesame state as the data container. For example, if a data grid is groupedand/or filtered then the report view will be of the grouped and filteredset of data. These reports are designed for on the fly real-time typereports.

Formatted—These reports are pre-defined and have a more professionallook than ad hoc reports. These are the reports that are sent to othersas a more formal document.

Metric based—These reports correlate data into a pivot grid like reportstructure. These reports are good for tracking certain sets of data overtime.

Charts—These are charts may be formatted as histograms, pie charts, barecharts etc. . . .

The reporting interface allows the user to define the report type anddata to collect as well as save the report to internal or export reportsto other data formats.

The Data Request Process builds the sql (or other) statement thatrequests data from a backend. Queries may be simple, complex, nested,multi dimensional, etc., and will take into account future dataextraction technologies.

The exemplary Transaction Process allows adding, deleting and modifyingidentities and other records and follows a straight forward transactionprocess. The process provides for the guarantee of the integrity andreliability of data and meets federal standards under HSPD-12 foridentity verification in a government environment.

Exemplary Components include:

1. Transaction tracking mechanism (GUID, UUID, or any certificate).2. Authentication medium (smartcards, chips, and any other data storagemedium whether its embedded, imbedded, attached, not attached etc. . . .)3. Authentication factor (something a person has, something a personknows, who a person is, time, space etc. . . . )4. Storage mediums (relational data structures, active directory, chipsand other mediums).Integrity and reliability of identity information can be done throughtransaction and data tracking through storage devices and authenticationmediums through the use of1. GUID—globally unique identifiers2. UUIDs—universally unique identifiers3. Certificates (any type)4. Other unique markers as they are developed.GUIDs, UUIDs, or any certificate(s) and other markers can be used touniquely identify an identity across local, regional, national andinternational structures whether they are storage structure orauthentications mediums. An identity can be uniquely correlated throughconnected or disconnected space and time through any of the abovemarkers. Considering the fact that certain attributes of personal orprivate data can't be transmitted in some cases, the uniquemarker/identifier provides a means to validate an identity without theloss or compromise of sensitive data. If sensitive data needs to beaccessed the unique marker/identifier can be used as a lookup structureto a storage medium or to an authentication medium for additionalsensitive data.

By using these markers and identifiers it is possible to replicateidentities across multiple remote data stores locally, regionally,nationally or internationally without losing integrity. This also allowsfor near real-time updates for immediate identity visibility.

While the above-described flowcharts have been discussed in relation toa particular sequence of events, it should be appreciated that changesto this sequence can occur without materially effecting the operation ofthe invention. Additionally, the exact sequence of events need not occuras set forth in the exemplary embodiments, but rather the steps can beperformed by one or more of the elements described. Additionally, theexemplary techniques illustrated herein are not limited to thespecifically illustrated embodiments but can also be utilized with theother exemplary embodiments and each described feature is individuallyand separately claimable.

The above-described system can be implemented on one or more secured,hardened and/or unsecured computer systems and related components, andmay be connected to other systems, data feeds, network(s), etc., via asecure or unsecured or encrypted wired and/or wireless wide/local areanetwork system, a satellite communication system, a modem, or the like,or on a separate programmed general purpose computer having acommunications device.

Additionally, the systems, methods and protocols of this invention canbe implemented on a special purpose computer(s), a programmedmicroprocessor or microcontroller and peripheral integrated circuitelement(s), an ASIC or other integrated circuit, a digital signalprocessor, a hard-wired electronic or logic circuit such as discreteelement circuit, a programmable logic device such as PLD, PLA, FPGA,PAL, any comparable means, or the like. In general, any device capableof implementing a state machine that is in turn capable of implementingthe methodology illustrated herein can be used to implement the varioussystems and techniques described in relation to this invention.

Furthermore, the disclosed methods may be readily implemented insoftware using object or object-oriented software developmentenvironments that provide portable source code that can be used on avariety of computer or workstation platforms. Alternatively, thedisclosed system may be implemented partially or fully in hardware usingstandard logic circuits or VLSI design. Whether software or hardware isused to implement the systems in accordance with this invention isdependent on the speed and/or efficiency requirements of the system, theparticular function, and the particular software or hardware systems ormicroprocessor or microcomputer systems being utilized. The systems,methods and protocols illustrated herein can be readily implemented inhardware and/or software using any known or later developed systems orstructures, devices and/or software by those of ordinary skill in theapplicable art from the functional description provided herein and witha general basic knowledge of the computer and logical and physicalsecurity arts.

Moreover, the disclosed methods may be readily implemented in softwarethat can be stored on a storage medium, executed on programmedgeneral-purpose computer with the cooperation of a controller andmemory, a special purpose computer, a microprocessor, or the like. Inthese instances, the systems and methods of this invention can beimplemented as program embedded on personal computer such as an applet,JAVA® or CGI script, as a resource residing on a server or computerworkstation, as a routine embedded in a dedicated communication systemor system component, or the like. The system can also be implemented byphysically incorporating the system and/or method into a software and/orhardware system, such as the hardware and software systems of a securitysystem.

It is therefore apparent that there has been provided, in accordancewith the present invention, systems and methods for combined IT/Networkand physical security management. While this invention has beendescribed in conjunction with a number of embodiments, it is evidentthat many alternatives, modifications and variations would be or areapparent to those of ordinary skill in the applicable arts. Accordingly,it is intended to embrace all such alternatives, modifications,equivalents and variations that are within the spirit and scope of thisinvention.

APPENDIX Exemplary Relational Database information for use withexemplary security system and relational database figure. Entity list #attrib- Entity name Entity type Primary key utes Access independentAccess_ID 8 Account independent Acct_ID 13 Acct_Hours dependent Hrs_ID,Acct_ID 3 AD dependent Acct_ID 1 Audio dependent EVT_ID, Aud_ID 7 Certsindependent Cert_ID 6 Doc_Auth dependent Auth_ID, Doc_ID, EVT_ID 7 Docsdependent Doc_ID, EVT_ID 11 Equipment dependent Org_ID, Equip_ID 9Events independent EVT_ID 13 Evt_Log dependent Log_ID, EVT_ID 9 Graphdependent EVT_ID, Graph_ID 8 Historical dependent Hist_ID, EVT_ID 8 JTaccevt dependent EVT_ID, Access_ID 2 JT org_evt dependent Org_ID, EVT_ID2 JT pers_certs dependent Org_ID, Pers_ID, Cert_ID 3 JT_Acct_Readdependent Acct_ID, Read_ID 2 JT_Org_Tsk dependent Org_ID, Task_ID, 3Task_Name Logs independent Log_ID 11 Org_cht dependent Cht_mast_ID,EVT_ID 5 Organization independent Org_ID 7 Package dependent Package_ID,EVT_ID 8 Personnel dependent Org_ID, Pers_ID 10 Readers independentRead_ID 7 Reps_agency dependent ARep_ID, EVT_ID 8 Reps_Tech dependentTR_ID, EVT_ID 8 Schedule dependent Sched_ID, EVT_ID 4 Sens_Pts dependentPt_ID, EVT_ID, Sens_ID 6 Sensor dependent EVT_ID, Sens_ID 12 SITREPdependent Sit_ID, EVT_ID 16 Tasks independent Task_ID, Task_Name 9 Videodependent Vid_ID, EVT_ID 7 VOIP dependent VOIP_ID, EVT_ID 8 Entity‘Access’ General info Entity type: independent Attributes KeyAttribute/role name Data type Not null Unique PK Access_IDUniqueIdentifier YES YES Access_Date DateTime YES YES Access_TimeDateTime NO NO Identity UniqueIdentifier NO NO Access_FName Char (20) NONO Access_LName Char (20) NO NO Access_Type Char (20) NO NO Access_PointChar (20) NO NO Relationships Relationship name Type Parent entity Childentity Card. Relationship162 Identifying Access JT accevt 1:NUser-defined variables Name Value Owner Non clustered primary key NoPrimary key fill factor Data space for Table Data space for Primary keyText Filegroup for Table (TEXTIMAGE_ON) Entity ‘Account’ General infoEntity type: independent Attributes Key Attribute/role name Data typeNot null Unique PK Acct_ID UniqueIdentifier YES YES Acct_FName Char (20)NO NO Acct_LName Char (20) NO NO Acct_Type Char (20) NO NO Acct_PurposeChar (20) NO NO Acct_Reason Char (30) NO NO Acct_Desc Text NO NOAcct_Expires Char (1) NO NO Acct_Image Image NO NO Acct_NHours Char (25)NO NO Acct_PHours Char (25) NO NO Acct_Zone Char (15) NO NO Acct_RemText NO NO Relationships Parent Relationship name Type entity Childentity Card. Relationship38 Identifying Account JT_Acct_Read 1:NRelationship40 Identifying Account AD 1:N Relationship41 IdentifyingAccount Acct_Hours 1:N User-defined variables Name Value Owner Nonclustered primary key No Primary key fill factor Data space for TableData space for Primary key Text Filegroup for Table (TEXTIMAGE_ON)Entity ‘Acct_Hours’ General info Entity type: dependent Attributes KeyAttribute/role name Data type Not null Unique PK Hrs_ID UniqueIdentifierYES YES Hrs_Value Char (1) NO NO PFK Acct_ID UniqueIdentifier YES NORelationships Relationship name Type Parent entity Child entity Card.Relationship41 Identifying Account Acct_Hours 1:N User-defined variablesName Value Owner Non clustered primary key No Primary key fill factorData space for Table Data space for Primary key Text Filegroup for Table(TEXTIMAGE_ON) Entity ‘AD’ General info Entity type: dependentAttributes Key Attribute/role name Data type Not null Unique PFK Acct_IDUniqueIdentifier YES NO Relationships Relationship name Type Parententity Child entity Card. Relationship40 Identifying Account AD 1:NUser-defined variables Name Value Owner Non clustered primary key NoPrimary key fill factor Data space for Table Data space for Primary keyText Filegroup for Table (TEXTIMAGE_ON) Entity ‘Audio’ General infoEntity type: dependent Attributes Key Attribute/role name Data type Notnull Unique PFK EVT_ID UniqueIdentifier YES NO PK Aud_IDUniqueIdentifier YES YES Aud_Name VarChar (50) NO NO Aud_Desc Char (1)NO NO Aud_Date DateTime NO NO Aud_Time DateTime NO NO Aud_Sens Char (15)NO NO Relationships Relationship name Type Parent entity Child entityCard. Relationship122 Identifying Events Audio 1:N User-definedvariables Name Value Owner Non clustered primary key No Primary key fillfactor Data space for Table Data space for Primary key Text Filegroupfor Table (TEXTIMAGE_ON) Entity ‘Certs’ General info Entity type:independent Attributes Key Attribute/role name Data type Not null UniquePK Cert_ID UniqueIdentifier YES YES Cert_Cert VarChar (50) NO NOCert_Date DateTime NO NO Cert_Expire DateTime NO NO Cert_Type Char (20)NO NO Cert_Auth Char (15) NO NO Relationships Relationship name TypeParent entity Child entity Card. Relationship282 Identifying Certs JTpers_certs 1:N User-defined variables Name Value Owner Non clusteredprimary key No Primary key fill factor Data space for Table Data spacefor Primary key Text Filegroup for Table (TEXTIMAGE_ON) Entity‘Doc_Auth’ General info Entity type: dependent Attributes KeyAttribute/role name Data type Not null Unique PK Auth_IDUniqueIdentifier YES YES Auth_User UniqueIdentifier NO NOAuth_Start_Date DateTime NO NO End_Auth_Date DateTime NO NO Auth_TypeChar (20) NO NO PFK Doc_ID UniqueIdentifier YES NO PFK EVT_IDUniqueIdentifier YES NO Relationships Relationship name Type Parententity Child entity Card. Relationship37 Identifying Docs Doc_Auth 1:NUser-defined variables Name Value Owner Non clustered primary key NoPrimary key fill factor Data space for Table Data space for Primary keyText Filegroup for Table (TEXTIMAGE_ON) Entity ‘Docs’ General infoEntity type: dependent Attributes Key Attribute/role name Data type Notnull Unique PK Doc_ID UniqueIdentifier YES YES Doc_Name VarChar (50) NONO Doc_Type Char (20) NO NO Dec_Sens Char (15) NO NO Doc_Doc VarBinary(512) NO NO Doc_Img Image NO NO Doc_Date DateTime NO NO Doc_TimeDateTime NO NO Doc_Author VarChar (50) NO NO Doc_Rem Text NO NO PFKEVT_ID UniqueIdentifier YES NO Relationships Relationship name TypeParent entity Child entity Card. Relationship36 Identifying Events Docs1:N Relationship37 Identifying Docs Doc_Auth 1:N User-defined variablesName Value Owner Non clustered primary key No Primary key fill factorData space for Table Data space for Primary key Text Filegroup for Table(TEXTIMAGE_ON) Entity ‘Equipment’ General info Entity type: dependentAttributes Key Attribute/role name Data type Not null Unique PFK Org_IDUniqueIdentifier YES NO PK Equip_ID UniqueIdentifier YES YES Equip_NameVarChar (50) NO NO Equip_Desc Text NO NO Equip_Serial Char (20) NO NOEquip_Model Char (20) NO NO Equip_Task VarChar (1) NO NO Special_ReqText NO NO Equip_Rem Text NO NO Relationships Relationship name TypeParent entity Child entity Card. Relationship28 Identifying OrganizationEquipment 1:N User-defined variables Name Value Owner Non clusteredprimary key No Primary key fill factor Data space for Table Data spacefor Primary key Text Filegroup for Table (TEXTIMAGE_ON) Entity ‘Events’General info Entity type: independent Attributes Key Attribute/role nameData type Not null Unique PK EVT_ID UniqueIdentifier YES YES Evt_nameVarChar (50) NO NO Evt_Open_Date DateTime NO NO EVT_Open_Time DateTimeNO NO Evt_close_Date DateTime NO NO EVT_Close_Time DateTime NO NOEvt_Sensitivity Char (15) NO NO Evt_Criticality Char (15) NO NOEVT_General_Loc Text NO NO Evt_Inter_Loc Text NO NO Evt_Pinpoint_LocText NO NO Evt_CMDR VarChar (50) NO NO Evt_Loc VarChar (50) NO NORelationships Relationship name Type Parent entity Child entity Card.Relationship22 Identifying Events JT org_evt 1:N Relationship62Identifying Events Sensor 1:N Relationship92 Identifying Events Graph1:N Relationship122 Identifying Events Audio 1:N Relationship152Identifying Events JT accevt 1:N Relationship23 Identifying EventsOrg_cht 1:N Relationship24 Identifying Events SITREP 1:N Relationship25Identifying Events Reps_agency 1:N Relationship26 Identifying EventsReps_Tech 1:N Relationship33 Identifying Events Package 1:NRelationship34 Identifying Events Evt_Log 1:N Relationship35 IdentifyingEvents Historical 1:N Relationship36 Identifying Events Docs 1:NRelationship42 Identifying Events VOIP 1:N Relationship43 IdentifyingEvents Schedule 1:N Relationship44 Identifying Events Video 1:NUser-defined variables Name Value Owner Non clustered primary key NoPrimary key fill factor Data space for Table Data space for Primary keyText Filegroup for Table (TEXTIMAGE_ON) Entity ‘Evt_Log’ General infoEntity type: dependent Attributes Key Attribute/role name Data type Notnull Unique PK Log_ID UniqueIdentifier YES YES Lg_Entry VarChar (50) NONO Lg_Date DateTime NO NO Lg_Time Char (1) NO NO Lg_Agency VarChar (50)NO NO Lg_Crit Char (20) NO NO Lg_Sens Char (20) NO NO Lg_Txt Char (1) NONO PFK EVT_ID UniqueIdentifier YES NO Relationships Relationship nameType Parent entity Child entity Card. Relationship34 Identifying EventsEvt_Log 1:N User-defined variables Name Value Owner Non clusteredprimary key No Primary key fill factor Data space for Table Data spacefor Primary key Text Filegroup for Table (TEXTIMAGE_ON) Entity ‘Graph’General info Entity type: dependent Attributes Key Attribute/role nameData type Not null Unique PFK EVT_ID UniqueIdentifier YES NO PK Graph_IDUniqueIdentifier YES YES Graph_Name VarChar (50) NO NO Graph_Desc TextNO NO Graph_Date_Time DateTime NO NO Graph_Sensitivity Char (15) NO NOGraph_Graphic Image NO NO Graphic_Type Char (15) NO NO RelationshipsRelationship name Type Parent entity Child entity Card. Relationship92Identifying Events Graph 1:N User-defined variables Name Value Owner Nonclustered primary key No Primary key fill factor Data space for TableData space for Primary key Text Filegroup for Table (TEXTIMAGE_ON)Entity ‘Historical’ General info Entity type: dependent Attributes KeyAttribute/role name Data type Not null Unique PK Hist_IDUniqueIdentifier YES YES Hist_Name VarChar (50) NO NO Hist_Date DateTimeNO NO Hist_Desc Text NO NO Hist_Evt_Type Char (1) NO NO Hist_CMDRVarChar (50) NO NO Hist_Doc Char (1) NO NO PFK EVT_ID UniqueIdentifierYES NO Relationships Relationship name Type Parent entity Child entityCard. Relationship35 Identifying Events Historical 1:N User-definedvariables Name Value Owner Non clustered primary key No Primary key fillfactor Data space for Table Data space for Primary key Text Filegroupfor Table (TEXTIMAGE_ON) Entity ‘JT accevt’ General info Entity type:dependent Attributes Key Attribute/role name Data type Not null UniquePFK EVT_ID UniqueIdentifier YES NO PFK Access_ID UniqueIdentifier YES NORelationships Relationship name Type Parent entity Child entity Card.Relationship152 Identifying Events JT accevt 1:N Relationship162Identifying Access JT accevt 1:N User-defined variables Name Value OwnerNon clustered primary key No Primary key fill factor Data space forTable Data space for Primary key Text Filegroup for Table (TEXTIMAGE_ON)Entity ‘JT org_evt’ General info Entity type: dependent Attributes KeyAttribute/role name Data type Not null Unique PFK Org_IDUniqueIdentifier YES NO PFK EVT_ID UniqueIdentifier YES NO RelationshipsRelationship name Type Parent entity Child entity Card. Relationship12Identifying Organization JT org_evt 1:N Relationship22 IdentifyingEvents JT org_evt 1:N User-defined variables Name Value Owner Nonclustered primary key No Primary key fill factor Data space for TableData space for Primary key Text Filegroup for Table (TEXTIMAGE_ON)Entity ‘JT pers_certs’ General info Entity type: dependent AttributesKey Attribute/role name Data type Not null Unique PFK Org_IDUniqueIdentifier YES NO PFK Pers_ID UniqueIdentifier YES NO PFK Cert_IDUniqueIdentifier YES NO Relationships Relationship name Type Parententity Child entity Card. Relationship272 Identifying Personnel JTpers_certs 1:N Relationship282 Identifying Certs JT pers_certs 1:NUser-defined variables Name Value Owner Non clustered primary key NoPrimary key fill factor Data space for Table Data space for Primary keyText Filegroup for Table (TEXTIMAGE_ON) Entity ‘JT_Acct_Read’ Generalinfo Entity type: dependent Attributes Key Attribute/role name Data typeNot null Unique PFK Acct_ID UniqueIdentifier YES NO PFK Read_IDUniqueIdentifier YES NO Relationships Parent Relationship name Typeentity Child entity Card. Relationship38 Identifying AccountJT_Acct_Read 1:N Relationship39 Identifying Readers JT_Acct_Read 1:NUser-defined variables Name Value Owner Non clustered primary key NoPrimary key fill factor Data space for Table Data space for Primary keyText Filegroup for Table (TEXTIMAGE_ON) Entity ‘JT_Org_Tsk’ General infoEntity type: dependent Attributes Key Attribute/role name Data type Notnull Unique PFK Org_ID UniqueIdentifier YES NO PFK Task_IDUniqueIdentifier YES NO PFK Task_Name VarChar (50) YES NO RelationshipsRelationship name Type Parent entity Child entity Card. Relationship29Identifying Organization JT_Org_Tsk 1:N Relationship30 Identifying TasksJT_Org_Tsk 1:N User-defined variables Name Value Owner Non clusteredprimary key No Primary key fill factor Data space for Table Data spacefor Primary key Text Filegroup for Table (TEXTIMAGE_ON) Entity ‘Logs’General info Entity type: independent Attributes Key Attribute/role nameData type Not null Unique PK Log_ID UniqueIdentifier YES YES Log_EventChar (25) NO NO Log_Evt_Type Char (20) NO NO Log_Date DateTime NO NOLog_Time DateTime NO NO Log_Desc Char (35) NO NO Log_Text Text NO NOLog_User VarBinary (50) NO NO Log_Sys Char (20) NO NO Log_Priority Char(20) NO NO Log_Alerts Char (20) NO NO User-defined variables Name ValueOwner Non clustered primary key No Primary key fill factor Data spacefor Table Data space for Primary key Text Filegroup for Table(TEXTIMAGE_ON) Entity ‘Org_cht’ General info Entity type: dependentAttributes Key Attribute/role name Data type Not null Unique PKCht_mast_ID UniqueIdentifier YES YES PFK EVT_ID UniqueIdentifier YES NOCht_M_Name VarChar (50) NO NO Cht_M_Desc Text NO NO Cht_M_Data Image NONO Relationships Relationship name Type Parent entity Child entity Card.Relationship23 Identifying Events Org_cht 1:N User-defined variablesName Value Owner Non clustered primary key No Primary key fill factorData space for Table Data space for Primary key Text Filegroup for Table(TEXTIMAGE_ON) Entity ‘Organization’ General info Entity type:independent Attributes Key Attribute/role name Data type Not null UniquePK Org_ID UniqueIdentifier YES YES Org_Name VarChar (50) NO NOOrg_Address VarChar (64) NO NO Org_city VarChar (35) NO NO Org_StateChar (20) NO NO Org_Zip SmallInt NO NO Org_POC VarChar (50) NO NORelationships Relationship name Type Parent entity Child entity Card.Relationship12 Identifying Organization JT org_evt 1:N Relationship27Identifying Organization Personnel 1:N Relationship28 IdentifyingOrganization Equipment 1:N Relationship29 Identifying OrganizationJT_Org_Tsk 1:N User-defined variables Name Value Owner Non clusteredprimary key No Primary key fill factor Data space for Table Data spacefor Primary key Text Filegroup for Table (TEXTIMAGE_ON) Entity ‘Package’General info Entity type: dependent Attributes Key Attribute/role nameData type Not null Unique PK Package_ID UniqueIdentifier YES YESPkg_Name VarChar (50) NO NO Pkg_type Char (20) NO NO Pkg_def Char (20)NO NO Pkg_Status Char (20) NO NO Pkg_S_Date DateTime NO NO Pkg_E_DateDateTime NO NO PFK EVT_ID UniqueIdentifier YES NO RelationshipsRelationship name Type Parent entity Child entity Card. Relationship33Identifying Events Package 1:N User-defined variables Name Value OwnerNon clustered primary key No Primary key fill factor Data space forTable Data space for Primary key Text Filegroup for Table (TEXTIMAGE_ON)Entity ‘Personnel’ General info Entity type: dependent Attributes KeyAttribute/role name Data type Not null Unique PFK Org_IDUniqueIdentifier YES NO PK Pers_ID UniqueIdentifier YES YES Pers_FNameChar (20) NO NO Pers_LName Char (20) NO NO Pers_Status Char (15) NO NOPers_Cost Money NO NO Pers_DOB DateTime NO NO Pers_Blood Char (10) NO NOPers_Clear Char (15) NO NO Pers_Duty VarChar (128) NO NO RelationshipsRelationship name Type Parent entity Child entity Card. Relationship272Identifying Personnel JT pers_certs 1:N Relationship27 IdentifyingOrganization Personnel 1:N User-defined variables Name Value Owner Nonclustered primary key No Primary key fill factor Data space for TableData space for Primary key Text Filegroup for Table (TEXTIMAGE_ON)Entity ‘Readers’ General info Entity type: independent Attributes KeyAttribute/role name Data type Not null Unique PK Read_IDUniqueIdentifier YES YES Read_Name VarChar (50) NO NO Read_Desc Text NONO Read_Grp VarChar (50) NO NO Read_Active Bit NO NO Read_Lat Char (25)NO NO Read_long Char (25) NO NO Relationships Parent Relationship nameType entity Child entity Card. Relationship39 Identifying ReadersJT_Acct_Read 1:N User-defined variables Name Value Owner Non clusteredprimary key No Primary key fill factor Data space for Table Data spacefor Primary key Text Filegroup for Table (TEXTIMAGE_ON) Entity‘Reps_agency’ General info Entity type: dependent Attributes KeyAttribute/role name Data type Not null Unique PK ARep_IDUniqueIdentifier YES YES AR_FName Char (20) NO NO AR_LName Char (20) NONO AR_Agency VarChar (50) NO NO AR_Start DateTime NO NO AR_End DateTimeNO NO AR_Rem Text NO NO PFK EVT_ID UniqueIdentifier YES NO RelationshipsRelationship name Type Parent entity Child entity Card. Relationship25Identifying Events Reps_agency 1:N User-defined variables Name ValueOwner Non clustered primary key No Primary key fill factor Data spacefor Table Data space for Primary key Text Filegroup for Table(TEXTIMAGE_ON) Entity ‘Reps_Tech’ General info Entity type: dependentAttributes Key Attribute/role name Data type Not null Unique PK TR_IDUniqueIdentifier YES YES TR_FName Char (20) NO NO TR_LName Char (20) NONO TR_Agency VarChar (50) NO NO TR_Start DateTime NO NO TR_End DateTimeNO NO TR_Rem Text NO NO PFK EVT_ID UniqueIdentifier YES NO RelationshipsRelationship name Type Parent entity Child entity Card. Relationship26Identifying Events Reps_Tech 1:N User-defined variables Name Value OwnerNon clustered primary key No Primary key fill factor Data space forTable Data space for Primary key Text Filegroup for Table (TEXTIMAGE_ON)Entity ‘Schedule’ General info Entity type: dependent Attributes KeyAttribute/role name Data type Not null Unique PK Sched_IDUniqueIdentifier YES YES Sched_Name VarChar (50) NO NO Sched_Data Binary(512) NO NO PFK EVT_ID UniqueIdentifier YES NO RelationshipsRelationship name Type Parent entity Child entity Card. Relationship43Identifying Events Schedule 1:N User-defined variables Name Value OwnerNon clustered primary key No Primary key fill factor Data space forTable Data space for Primary key Text Filegroup for Table (TEXTIMAGE_ON)Entity ‘Sens_Pts’ General info Entity type: dependent Attributes KeyAttribute/role name Data type Not null Unique PK Pt_ID UniqueIdentifierYES YES PT_Date DateTime NO NO PT_Time Char (1) NO NO PT_Value Char (1)NO NO PFK EVT_ID UniqueIdentifier YES NO PFK Sens_ID UniqueIdentifierYES NO Relationships Relationship name Type Parent entity Child entityCard. Relationship22 Identifying Sensor Sens_Pts 1:N User-definedvariables Name Value Owner Non clustered primary key No Primary key fillfactor Data space for Table Data space for Primary key Text Filegroupfor Table (TEXTIMAGE_ON) Entity ‘Sensor’ General info Entity type:dependent Attributes Key Attribute/role name Data type Not null UniquePFK EVT_ID UniqueIdentifier YES NO PK Sens_ID UniqueIdentifier YES YESSens_Name VarChar (50) NO NO Sens_Desc Text NO NO Sens_Deploy_DateDateTime NO NO Sens_Close_Date Char (1) NO NO Sens_Deploy_Time DateTimeNO NO Sens_Close_Time DateTime NO NO Sens_Long Char (45) NO NO Sens_LatChar (45) NO NO Sens_Type Char (1) NO NO Sens_Remarks Text NO NORelationships Relationship name Type Parent entity Child entity Card.Relationship62 Identifying Events Sensor 1:N Relationship22 IdentifyingSensor Sens_Pts 1:N User-defined variables Name Value Owner Nonclustered primary key No Primary key fill factor Data space for TableData space for Primary key Text Filegroup for Table (TEXTIMAGE_ON)Entity ‘SITREP’ General info Entity type: dependent Attributes KeyAttribute/role name Data type Not null Unique PK Sit_ID UniqueIdentifierYES YES Sit_Name VarChar (50) NO NO Sit_Date DateTime NO NO Sit_TimeChar (1) NO NO Sit_Agency Char (1) NO NO Sit_Asset Char (1) NO NOSit_Situation VarChar (64) NO NO Sit_Act VarChar (64) NO NO Sit_LocVarChar (64) NO NO Sit_Elem VarChar (64) NO NO Sit_Assets VarChar (64)NO NO Sit_tht VarChar (64) NO NO Sit_sev VarChar (64) NO NO Sit_ImpVarChar (64) NO NO Sit_rem Text NO NO PFK EVT_ID UniqueIdentifier YES NORelationships Relationship name Type Parent entity Child entity Card.Relationship24 Identifying Events SITREP 1:N User-defined variables NameValue Owner Non clustered primary key No Primary key fill factor Dataspace for Table Data space for Primary key Text Filegroup for Table(TEXTIMAGE_ON) Entity ‘Tasks’ General info Entity type: independentAttributes Key Attribute/role name Data type Not null Unique PK Task_IDUniqueIdentifier YES YES PK Task_Name VarChar (50) YES YES Task_DescText NO NO Task_Iss_Date DateTime NO NO Task_Comp_Date Char (1) NO NOTask_No_Later_Date Char (1) NO NO Task_Agency Char (1) NO NO Task_RemChar (1) NO NO Task_Ass_By VarChar (1) NO NO Relationships Relationshipname Type Parent entity Child entity Card. Relationship30 IdentifyingTasks JT_Org_Tsk 1:N User-defined variables Name Value Owner Nonclustered primary key No Primary key fill factor Data space for TableData space for Primary key Text Filegroup for Table (TEXTIMAGE_ON)Entity ‘Video’ General info Entity type: dependent Attributes KeyAttribute/role name Data type Not null Unique PK Vid_ID UniqueIdentifierYES YES Vid_Name VarChar (50) NO NO Vid_Date DateTime NO NO Vid_TimeDateTime NO NO Vid_Data Binary (512) NO NO Vid_Desc Text NO NO PFKEVT_ID UniqueIdentifier YES NO Relationships Relationship name TypeParent entity Child entity Card. Relationship44 Identifying Events Video1:N User-defined variables Name Value Owner Non clustered primary key NoPrimary key fill factor Data space for Table Data space for Primary keyText Filegroup for Table (TEXTIMAGE_ON) Entity ‘VOIP’ General infoEntity type: dependent Attributes Key Attribute/role name Data type Notnull Unique PK VOIP_ID UniqueIdentifier YES YES VOIP_Name VarChar (50)NO NO VOIP_Date DateTime NO NO VOIP_Time DateTime NO NO VOIP_Sens Char(15) NO NO VOIP_Data Binary (512) NO NO VOIP_Rem Text NO NO PFK EVT_IDUniqueIdentifier YES NO Relationships Relationship name Type Parententity Child entity Card. Relationship42 Identifying Events VOIP 1:NUser-defined variables Name Value Owner Non clustered primary key NoPrimary key fill factor Data space for Table Data space for Primary keyText Filegroup for Table (TEXTIMAGE_ON) Access.Access_Date General infoEntity name Access Data type DateTime Not null YES Unique YESUser-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Access.Access_FName General info Entity name Access Datatype Char (20) Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Access.Access_ID General info Entityname Access Data type UniqueIdentifier Not null YES Unique YESUser-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColYes Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Access.Access_LName General info Entity name Access Datatype Char (20) Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Access.Access_Point General info Entityname Access Data type Char (20) Not null NO User-defined variables NameValue Unique Fill factor Identity No Identity Seed Identity IncrementDefault object Rule object RowGuidCol No Clustered unique No Not forreplication (Identity) No Not for replication (Check) No Data space forUnique Descending order (for Primary Key) No Descending order (forUnique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint NoAccess.Access_Time General info Entity name Access Data type DateTimeNot null NO User-defined variables Name Value Unique Fill factorIdentity No Identity Seed Identity Increment Default object Rule objectRowGuidCol No Clustered unique No Not for replication (Identity) No Notfor replication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Access.Access_Type General info Entity name Access Datatype Char (20) Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Access.Identity General info Entity nameAccess Data type UniqueIdentifier Not null NO User-defined variablesName Value Unique Fill factor Identity No Identity Seed IdentityIncrement Default object Rule object RowGuidCol No Clustered unique NoNot for replication (Identity) No Not for replication (Check) No Dataspace for Unique Descending order (for Primary Key) No Descending order(for Unique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No Account.Acct_DescGeneral info Entity name Account Data type Text Not null NO User-definedvariables Name Value Unique Fill factor Identity No Identity SeedIdentity Increment Default object Rule object RowGuidCol No Clusteredunique No Not for replication (Identity) No Not for replication (Check)No Data space for Unique Descending order (for Primary Key) NoDescending order (for Unique) No Override Null/NotNull by User Type NoGenerate Unique as unique Index No Collation for the column Maximumstorage size for varying types is “max” No Disabled check constraint NoAccount.Acct_Expires General info Entity name Account Data type Char (1)Not null NO User-defined variables Name Value Unique Fill factorIdentity No Identity Seed Identity Increment Default object Rule objectRowGuidCol No Clustered unique No Not for replication (Identity) No Notfor replication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Account.Acct_FName General info Entity name Account Datatype Char (20) Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Account.Acct_ID General info Entity nameAccount Data type UniqueIdentifier Not null YES Unique YES User-definedvariables Name Value Unique Fill factor Identity No Identity SeedIdentity Increment Default object Rule object RowGuidCol Yes Clusteredunique No Not for replication (Identity) No Not for replication (Check)No Data space for Unique Descending order (for Primary Key) NoDescending order (for Unique) No Override Null/NotNull by User Type NoGenerate Unique as unique Index No Collation for the column Maximumstorage size for varying types is “max” No Disabled check constraint NoAccount.Acct_Image General info Entity name Account Data type Image Notnull NO User-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Account.Acct_LName General info Entity name Account Datatype Char (20) Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Account.Acct_NHours General info Entityname Account Data type Char (25) Not null NO User-defined variables NameValue Unique Fill factor Identity No Identity Seed Identity IncrementDefault object Rule object RowGuidCol No Clustered unique No Not forreplication (Identity) No Not for replication (Check) No Data space forUnique Descending order (for Primary Key) No Descending order (forUnique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint NoAccount.Acct_PHours General info Entity name Account Data type Char (25)Not null NO User-defined variables Name Value Unique Fill factorIdentity No Identity Seed Identity Increment Default object Rule objectRowGuidCol No Clustered unique No Not for replication (Identity) No Notfor replication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Account.Acct_Purpose General info Entity name Account Datatype Char (20) Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Account.Acct_Reason General info Entityname Account Data type Char (30) Not null NO User-defined variables NameValue Unique Fill factor Identity No Identity Seed Identity IncrementDefault object Rule object RowGuidCol No Clustered unique No Not forreplication (Identity) No Not for replication (Check) No Data space forUnique Descending order (for Primary Key) No Descending order (forUnique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No Account.Acct_RemGeneral info Entity name Account Data type Text Not null NO User-definedvariables Name Value Unique Fill factor Identity No Identity SeedIdentity Increment Default object Rule object RowGuidCol No Clusteredunique No Not for replication (Identity) No Not for replication (Check)No Data space for Unique Descending order (for Primary Key) NoDescending order (for Unique) No Override Null/NotNull by User Type NoGenerate Unique as unique Index No Collation for the column Maximumstorage size for varying types is “max” No Disabled check constraint NoAccount.Acct_Type General info Entity name Account Data type Char (20)Not null NO User-defined variables Name Value Unique Fill factorIdentity No Identity Seed Identity Increment Default object Rule objectRowGuidCol No Clustered unique No Not for replication (Identity) No Notfor replication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Account.Acct_Zone General info Entity name Account Datatype Char (15) Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Acct_Hours.Acct_ID General info Entityname Acct_Hours Data type UniqueIdentifier Not null YES User-definedvariables Name Value Unique Fill factor Identity No Identity SeedIdentity Increment Default object Rule object RowGuidCol No Clusteredunique No Not for replication (Identity) No Not for replication (Check)No Data space for Unique Descending order (for Primary Key) NoDescending order (for Unique) No Override Null/NotNull by User Type NoGenerate Unique as unique Index No Collation for the column Maximumstorage size for varying types is “max” No Disabled check constraint NoAcct_Hours.Hrs_ID General info Entity name Acct_Hours Data typeUniqueIdentifier Not null YES Unique YES User-defined variables NameValue Unique Fill factor Identity No Identity Seed Identity IncrementDefault object Rule object RowGuidCol No Clustered unique No Not forreplication (Identity) No Not for replication (Check) No Data space forUnique Descending order (for Primary Key) No Descending order (forUnique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint NoAcct_Hours.Hrs_Value General info Entity name Acct_Hours Data type Char(1) Not null NO User-defined variables Name Value Unique Fill factorIdentity No Identity Seed Identity Increment Default object Rule objectRowGuidCol No Clustered unique No Not for replication (Identity) No Notfor replication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No AD.Acct_ID General info Entity name AD Data typeUniqueIdentifier Not null YES User-defined variables Name Value UniqueFill factor Identity No Identity Seed Identity Increment Default objectRule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Audio.Aud_Date General info Entity nameAudio Data type DateTime Not null NO User-defined variables Name ValueUnique Fill factor Identity No Identity Seed Identity Increment Defaultobject Rule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Audio.Aud_Desc General info Entity nameAudio Data type Char (1) Not null NO User-defined variables Name ValueUnique Fill factor Identity No Identity Seed Identity Increment Defaultobject Rule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Audio.Aud_ID General info Entity nameAudio Data type UniqueIdentifier Not null YES Unique YES User-definedvariables Name Value Unique Fill factor Identity No Identity SeedIdentity Increment Default object Rule object RowGuidCol Yes Clusteredunique No Not for replication (Identity) No Not for replication (Check)No Data space for Unique Descending order (for Primary Key) NoDescending order (for Unique) No Override Null/NotNull by User Type NoGenerate Unique as unique Index No Collation for the column Maximumstorage size for varying types is “max” No Disabled check constraint NoAudio.Aud_Name General info Entity name Audio Data type VarChar (50) Notnull NO User-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Audio.Aud_Sens General info Entity name Audio Data typeChar (15) Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Audio.Aud_Time General info Entity nameAudio Data type DateTime Not null NO User-defined variables Name ValueUnique Fill factor Identity No Identity Seed Identity Increment Defaultobject Rule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Audio.EVT_ID General info Entity nameAudio Data type UniqueIdentifier Not null YES User-defined variablesName Value Unique Fill factor Identity No Identity Seed IdentityIncrement Default object Rule object RowGuidCol No Clustered unique NoNot for replication (Identity) No Not for replication (Check) No Dataspace for Unique Descending order (for Primary Key) No Descending order(for Unique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No Certs.Cert_AuthGeneral info Entity name Certs Data type Char (15) Not null NOUser-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Certs.Cert_Cert General info Entity name Certs Data typeVarChar (50) Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Certs.Cert_Date General info Entity nameCerts Data type DateTime Not null NO User-defined variables Name ValueUnique Fill factor Identity No Identity Seed Identity Increment Defaultobject Rule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Certs.Cert_Expire General info Entityname Certs Data type DateTime Not null NO User-defined variables NameValue Unique Fill factor Identity No Identity Seed Identity IncrementDefault object Rule object RowGuidCol No Clustered unique No Not forreplication (Identity) No Not for replication (Check) No Data space forUnique Descending order (for Primary Key) No Descending order (forUnique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No Certs.Cert_IDGeneral info Entity name Certs Data type UniqueIdentifier Not null YESUnique YES User-defined variables Name Value Unique Fill factor IdentityNo Identity Seed Identity Increment Default object Rule objectRowGuidCol No Clustered unique No Not for replication (Identity) No Notfor replication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Certs.Cert_Type General info Entity name Certs Data typeChar (20) Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Doc_Auth.Auth_ID General info Entityname Doc_Auth Data type UniqueIdentifier Not null YES Unique YESUser-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColYes Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Doc_Auth.Auth_Start_Date General info Entity name Doc_AuthData type DateTime Not null NO User-defined variables Name Value UniqueFill factor Identity No Identity Seed Identity Increment Default objectRule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Doc_Auth.Auth_Type General info Entityname Doc_Auth Data type Char (20) Not null NO User-defined variablesName Value Unique Fill factor Identity No Identity Seed IdentityIncrement Default object Rule object RowGuidCol No Clustered unique NoNot for replication (Identity) No Not for replication (Check) No Dataspace for Unique Descending order (for Primary Key) No Descending order(for Unique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint NoDoc_Auth.Auth_User General info Entity name Doc_Auth Data typeUniqueIdentifier Not null NO User-defined variables Name Value UniqueFill factor Identity No Identity Seed Identity Increment Default objectRule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Doc_Auth.Doc_ID General info Entity nameDoc_Auth Data type UniqueIdentifier Not null YES User-defined variablesName Value Unique Fill factor Identity No Identity Seed IdentityIncrement Default object Rule object RowGuidCol No Clustered unique NoNot for replication (Identity) No Not for replication (Check) No Dataspace for Unique Descending order (for Primary Key) No Descending order(for Unique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint NoDoc_Auth.End_Auth_Date General info Entity name Doc_Auth Data typeDateTime Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Doc_Auth.EVT_ID General info Entity nameDoc_Auth Data type UniqueIdentifier Not null YES User-defined variablesName Value Unique Fill factor Identity No Identity Seed IdentityIncrement Default object Rule object RowGuidCol No Clustered unique NoNot for replication (Identity) No Not for replication (Check) No Dataspace for Unique Descending order (for Primary Key) No Descending order(for Unique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No Docs.Dec_SensGeneral info Entity name Docs Data type Char (15) Not null NOUser-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Docs.Doc_Author General info Entity name Docs Data typeVarChar (50) Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Docs.Doc_Date General info Entity nameDocs Data type DateTime Not null NO User-defined variables Name ValueUnique Fill factor Identity No Identity Seed Identity Increment Defaultobject Rule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Docs.Doc_Doc General info Entity nameDocs Data type VarBinary (512) Not null NO User-defined variables NameValue Unique Fill factor Identity No Identity Seed Identity IncrementDefault object Rule object RowGuidCol No Clustered unique No Not forreplication (Identity) No Not for replication (Check) No Data space forUnique Descending order (for Primary Key) No Descending order (forUnique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No Docs.Doc_IDGeneral info Entity name Docs Data type UniqueIdentifier Not null YESUnique YES User-defined variables Name Value Unique Fill factor IdentityNo Identity Seed Identity Increment Default object Rule objectRowGuidCol No Clustered unique No Not for replication (Identity) No Notfor replication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Docs.Doc_Img General info Entity name Docs Data type ImageNot null NO User-defined variables Name Value Unique Fill factorIdentity No Identity Seed Identity Increment Default object Rule objectRowGuidCol No Clustered unique No Not for replication (Identity) No Notfor replication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Docs.Doc_Name General info Entity name Docs Data typeVarChar (50) Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Docs.Doc_Rem General info Entity nameDocs Data type Text Not null NO User-defined variables Name Value UniqueFill factor Identity No Identity Seed Identity Increment Default objectRule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Docs.Doc_Time General info Entity nameDocs Data type DateTime Not null NO User-defined variables Name ValueUnique Fill factor Identity No Identity Seed Identity Increment Defaultobject Rule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Docs.Doc_Type General info Entity nameDocs Data type Char (20) Not null NO User-defined variables Name ValueUnique Fill factor Identity No Identity Seed Identity Increment Defaultobject Rule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Docs.EVT_ID General info Entity nameDocs Data type UniqueIdentifier Not null YES User-defined variables NameValue Unique Fill factor Identity No Identity Seed Identity IncrementDefault object Rule object RowGuidCol No Clustered unique No Not forreplication (Identity) No Not for replication (Check) No Data space forUnique Descending order (for Primary Key) No Descending order (forUnique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint NoEquipment.Equip_Desc General info Entity name Equipment Data type TextNot null NO User-defined variables Name Value Unique Fill factorIdentity No Identity Seed Identity Increment Default object Rule objectRowGuidCol No Clustered unique No Not for replication (Identity) No Notfor replication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Equipment.Equip_ID General info Entity name Equipment Datatype UniqueIdentifier Not null YES Unique YES User-defined variablesName Value Unique Fill factor Identity No Identity Seed IdentityIncrement Default object Rule object RowGuidCol Yes Clustered unique NoNot for replication (Identity) No Not for replication (Check) No Dataspace for Unique Descending order (for Primary Key) No Descending order(for Unique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint NoEquipment.Equip_Model General info Entity name Equipment Data type Char(20) Not null NO User-defined variables Name Value Unique Fill factorIdentity No Identity Seed Identity Increment Default object Rule objectRowGuidCol No Clustered unique No Not for replication (Identity) No Notfor replication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Equipment.Equip_Name General info Entity name EquipmentData type VarChar (50) Not null NO User-defined variables Name ValueUnique Fill factor Identity No Identity Seed Identity Increment Defaultobject Rule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Equipment.Equip_Rem General info Entityname Equipment Data type Text Not null NO User-defined variables NameValue Unique Fill factor Identity No Identity Seed Identity IncrementDefault object Rule object RowGuidCol No Clustered unique No Not forreplication (Identity) No Not for replication (Check) No Data space forUnique Descending order (for Primary Key) No Descending order (forUnique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint NoEquipment.Equip_Serial General info Entity name Equipment Data type Char(20) Not null NO User-defined variables Name Value Unique Fill factorIdentity No Identity Seed Identity Increment Default object Rule objectRowGuidCol No Clustered unique No Not for replication (Identity) No Notfor replication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Equipment.Equip_Task General info Entity name EquipmentData type VarChar (1) Not null NO User-defined variables Name ValueUnique Fill factor Identity No Identity Seed Identity Increment Defaultobject Rule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Equipment.Org_ID General info Entityname Equipment Data type UniqueIdentifier Not null YES User-definedvariables Name Value Unique Fill factor Identity No Identity SeedIdentity Increment Default object Rule object RowGuidCol No Clusteredunique No Not for replication (Identity) No Not for replication (Check)No Data space for Unique Descending order (for Primary Key) NoDescending order (for Unique) No Override Null/NotNull by User Type NoGenerate Unique as unique Index No Collation for the column Maximumstorage size for varying types is “max” No Disabled check constraint NoEquipment.Special_Req General info Entity name Equipment Data type TextNot null NO User-defined variables Name Value Unique Fill factorIdentity No Identity Seed Identity Increment Default object Rule objectRowGuidCol No Clustered unique No Not for replication (Identity) No Notfor replication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Events.Evt_close_Date General info Entity name Events Datatype DateTime Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Events.EVT_Close_Time General infoEntity name Events Data type DateTime Not null NO User-defined variablesName Value Unique Fill factor Identity No Identity Seed IdentityIncrement Default object Rule object RowGuidCol No Clustered unique NoNot for replication (Identity) No Not for replication (Check) No Dataspace for Unique Descending order (for Primary Key) No Descending order(for Unique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No Events.Evt_CMDRGeneral info Entity name Events Data type VarChar (50) Not null NOUser-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Events.Evt_Criticality General info Entity name EventsData type Char (15) Not null NO User-defined variables Name Value UniqueFill factor Identity No Identity Seed Identity Increment Default objectRule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Events.EVT_General_Loc General infoEntity name Events Data type Text Not null NO User-defined variablesName Value Unique Fill factor Identity No Identity Seed IdentityIncrement Default object Rule object RowGuidCol No Clustered unique NoNot for replication (Identity) No Not for replication (Check) No Dataspace for Unique Descending order (for Primary Key) No Descending order(for Unique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No Events.EVT_IDGeneral info Entity name Events Data type UniqueIdentifier Not null YESUnique YES User-defined variables Name Value Unique Fill factor IdentityNo Identity Seed Identity Increment Default object Rule objectRowGuidCol Yes Clustered unique No Not for replication (Identity) No Notfor replication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Events.Evt_Inter_Loc General info Entity name Events Datatype Text Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Events.Evt_Loc General info Entity nameEvents Data type VarChar (50) Not null NO User-defined variables NameValue Unique Fill factor Identity No Identity Seed Identity IncrementDefault object Rule object RowGuidCol No Clustered unique No Not forreplication (Identity) No Not for replication (Check) No Data space forUnique Descending order (for Primary Key) No Descending order (forUnique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No Events.Evt_nameGeneral info Entity name Events Data type VarChar (50) Not null NOUser-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Events.Evt_Open_Date General info Entity name Events Datatype DateTime Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Events.EVT_Open_Time General info Entityname Events Data type DateTime Not null NO User-defined variables NameValue Unique Fill factor Identity No Identity Seed Identity IncrementDefault object Rule object RowGuidCol No Clustered unique No Not forreplication (Identity) No Not for replication (Check) No Data space forUnique Descending order (for Primary Key) No Descending order (forUnique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint NoEvents.Evt_Pinpoint_Loc General info Entity name Events Data type TextNot null NO User-defined variables Name Value Unique Fill factorIdentity No Identity Seed Identity Increment Default object Rule objectRowGuidCol No Clustered unique No Not for replication (Identity) No Notfor replication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Events.Evt_Sensitivity General info Entity name EventsData type Char (15) Not null NO User-defined variables Name Value UniqueFill factor Identity No Identity Seed Identity Increment Default objectRule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Evt_Log.EVT_ID General info Entity nameEvt_Log Data type UniqueIdentifier Not null YES User-defined variablesName Value Unique Fill factor Identity No Identity Seed IdentityIncrement Default object Rule object RowGuidCol No Clustered unique NoNot for replication (Identity) No Not for replication (Check) No Dataspace for Unique Descending order (for Primary Key) No Descending order(for Unique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No Evt_Log.Lg_AgencyGeneral info Entity name Evt_Log Data type VarChar (50) Not null NOUser-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Evt_Log.Lg_Crit General info Entity name Evt_Log Data typeChar (20) Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Evt_Log.Lg_Date General info Entity nameEvt_Log Data type DateTime Not null NO User-defined variables Name ValueUnique Fill factor Identity No Identity Seed Identity Increment Defaultobject Rule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Evt_Log.Lg_Entry General info Entityname Evt_Log Data type VarChar (50) Not null NO User-defined variablesName Value Unique Fill factor Identity No Identity Seed IdentityIncrement Default object Rule object RowGuidCol No Clustered unique NoNot for replication (Identity) No Not for replication (Check) No Dataspace for Unique Descending order (for Primary Key) No Descending order(for Unique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No Evt_Log.Lg_SensGeneral info Entity name Evt_Log Data type Char (20) Not null NOUser-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Evt_Log.Lg_Time General info Entity name Evt_Log Data typeChar (1) Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Evt_Log.Lg_Txt General info Entity nameEvt_Log Data type Char (1) Not null NO User-defined variables Name ValueUnique Fill factor Identity No Identity Seed Identity Increment Defaultobject Rule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Evt_Log.Log_ID General info Entity nameEvt_Log Data type UniqueIdentifier Not null YES Unique YES User-definedvariables Name Value Unique Fill factor Identity No Identity SeedIdentity Increment Default object Rule object RowGuidCol Yes Clusteredunique No Not for replication (Identity) No Not for replication (Check)No Data space for Unique Descending order (for Primary Key) NoDescending order (for Unique) No Override Null/NotNull by User Type NoGenerate Unique as unique Index No Collation for the column Maximumstorage size for varying types is “max” No Disabled check constraint NoGraph.EVT_ID General info Entity name Graph Data type UniqueIdentifierNot null YES User-defined variables Name Value Unique Fill factorIdentity No Identity Seed Identity Increment Default object Rule objectRowGuidCol No Clustered unique No Not for replication (Identity) No Notfor replication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Graph.Graph_Date_Time General info Entity name Graph Datatype DateTime Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Graph.Graph_Desc General info Entityname Graph Data type Text Not null NO User-defined variables Name ValueUnique Fill factor Identity No Identity Seed Identity Increment Defaultobject Rule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Graph.Graph_Graphic General info Entityname Graph Data type Image Not null NO User-defined variables Name ValueUnique Fill factor Identity No Identity Seed Identity Increment Defaultobject Rule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Graph.Graph_ID General info Entity nameGraph Data type UniqueIdentifier Not null YES Unique YES User-definedvariables Name Value Unique Fill factor Identity No Identity SeedIdentity Increment Default object Rule object RowGuidCol No Clusteredunique No Not for replication (Identity) No Not for replication (Check)No Data space for Unique Descending order (for Primary Key) NoDescending order (for Unique) No Override Null/NotNull by User Type NoGenerate Unique as unique Index No Collation for the column Maximumstorage size for varying types is “max” No Disabled check constraint NoGraph.Graph_Name General info Entity name Graph Data type VarChar (50)Not null NO User-defined variables Name Value Unique Fill factorIdentity No Identity Seed Identity Increment Default object Rule objectRowGuidCol No Clustered unique No Not for replication (Identity) No Notfor replication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Graph.Graph_Sensitivity General info Entity name GraphData type Char (15) Not null NO User-defined variables Name Value UniqueFill factor Identity No Identity Seed Identity Increment Default objectRule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Graph.Graphic_Type General info Entityname Graph Data type Char (15) Not null NO User-defined variables NameValue Unique Fill factor Identity No Identity Seed Identity IncrementDefault object Rule object RowGuidCol No Clustered unique No Not forreplication (Identity) No Not for replication (Check) No Data space forUnique Descending order (for Primary Key) No Descending order (forUnique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No Historical.EVT_IDGeneral info Entity name Historical Data type UniqueIdentifier Not nullYES User-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Historical.Hist_CMDR General info Entity name HistoricalData type VarChar (50) Not null NO User-defined variables Name ValueUnique Fill factor Identity No Identity Seed Identity Increment Defaultobject Rule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Historical.Hist_Date General info Entityname Historical Data type DateTime Not null NO User-defined variablesName Value Unique Fill factor Identity No Identity Seed IdentityIncrement Default object Rule object RowGuidCol No Clustered unique NoNot for replication (Identity) No Not for replication (Check) No Dataspace for Unique Descending order (for Primary Key) No Descending order(for Unique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint NoHistorical.Hist_Desc General info Entity name Historical Data type TextNot null NO User-defined variables Name Value Unique Fill factorIdentity No Identity Seed Identity Increment Default object Rule objectRowGuidCol No Clustered unique No Not for replication (Identity) No Notfor replication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Historical.Hist_Doc General info Entity name HistoricalData type Char (1) Not null NO User-defined variables Name Value UniqueFill factor Identity No Identity Seed Identity Increment Default objectRule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Historical.Hist_Evt_Type General infoEntity name Historical Data type Char (1) Not null NO User-definedvariables Name Value Unique Fill factor Identity No Identity SeedIdentity Increment Default object Rule object RowGuidCol No Clusteredunique No Not for replication (Identity) No Not for replication (Check)No Data space for Unique Descending order (for Primary Key) NoDescending order (for Unique) No Override Null/NotNull by User Type NoGenerate Unique as unique Index No Collation for the column Maximumstorage size for varying types is “max” No Disabled check constraint NoHistorical.Hist_ID General info Entity name Historical Data typeUniqueIdentifier Not null YES Unique YES User-defined variables NameValue Unique Fill factor Identity No Identity Seed Identity IncrementDefault object Rule object RowGuidCol Yes Clustered unique No Not forreplication (Identity) No Not for replication (Check) No Data space forUnique Descending order (for Primary Key) No Descending order (forUnique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint NoHistorical.Hist_Name General info Entity name Historical Data typeVarChar (50) Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No JT accevt.Access_ID General info Entityname JT accevt Data type UniqueIdentifier Not null YES User-definedvariables Name Value Unique Fill factor Identity No Identity SeedIdentity Increment Default object Rule object RowGuidCol No Clusteredunique No Not for replication (Identity) No Not for replication (Check)No Data space for Unique Descending order (for Primary Key) NoDescending order (for Unique) No Override Null/NotNull by User Type NoGenerate Unique as unique Index No Collation for the column Maximumstorage size for varying types is “max” No Disabled check constraint NoJT accevt.EVT_ID General info Entity name JT accevt Data typeUniqueIdentifier Not null YES User-defined variables Name Value UniqueFill factor Identity No Identity Seed Identity Increment Default objectRule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No JT org_evt.EVT_ID General info Entityname JT org_evt Data type UniqueIdentifier Not null YES User-definedvariables Name Value Unique Fill factor Identity No Identity SeedIdentity Increment Default object Rule object RowGuidCol No Clusteredunique No Not for replication (Identity) No Not for replication (Check)No Data space for Unique Descending order (for Primary Key) NoDescending order (for Unique) No Override Null/NotNull by User Type NoGenerate Unique as unique Index No Collation for the column Maximumstorage size for varying types is “max” No Disabled check constraint NoJT org_evt.Org_ID General info Entity name JT org_evt Data typeUniqueIdentifier Not null YES User-defined variables Name Value UniqueFill factor Identity No Identity Seed Identity Increment Default objectRule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No JT pers_certs.Cert_ID General infoEntity name JT pers_certs Data type UniqueIdentifier Not null YESUser-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No JT pers_certs.Org_ID General info Entity name JTpers_certs Data type UniqueIdentifier Not null YES User-definedvariables Name Value Unique Fill factor Identity No Identity SeedIdentity Increment Default object Rule object RowGuidCol No Clusteredunique No Not for replication (Identity) No Not for replication (Check)No Data space for Unique Descending order (for Primary Key) NoDescending order (for Unique) No Override Null/NotNull by User Type NoGenerate Unique as unique Index No Collation for the column Maximumstorage size for varying types is “max” No Disabled check constraint NoJT pers_certs.Pers_ID General info Entity name JT pers_certs Data typeUniqueIdentifier Not null YES User-defined variables Name Value UniqueFill factor Identity No Identity Seed Identity Increment Default objectRule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No JT_Acct_Read.Acct_ID General info Entityname JT_Acct_Read Data type UniqueIdentifier Not null YES User-definedvariables Name Value Unique Fill factor Identity No Identity SeedIdentity Increment Default object Rule object RowGuidCol No Clusteredunique No Not for replication (Identity) No Not for replication (Check)No Data space for Unique Descending order (for Primary Key) NoDescending order (for Unique) No Override Null/NotNull by User Type NoGenerate Unique as unique Index No Collation for the column Maximumstorage size for varying types is “max” No Disabled check constraint NoJT_Acct_Read.Read_ID General info Entity name JT_Acct_Read Data typeUniqueIdentifier Not null YES User-defined variables Name Value UniqueFill factor Identity No Identity Seed Identity Increment Default objectRule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No JT_Org_Tsk.Org_ID General info Entityname JT_Org_Tsk Data type UniqueIdentifier Not null YES User-definedvariables Name Value Unique Fill factor Identity No Identity SeedIdentity Increment Default object Rule object RowGuidCol No Clusteredunique No Not for replication (Identity) No Not for replication (Check)No Data space for Unique Descending order (for Primary Key) NoDescending order (for Unique) No Override Null/NotNull by User Type NoGenerate Unique as unique Index No Collation for the column Maximumstorage size for varying types is “max” No Disabled check constraint NoJT_Org_Tsk.Task_ID General info Entity name JT_Org_Tsk Data typeUniqueIdentifier Not null YES User-defined variables Name Value UniqueFill factor Identity No Identity Seed Identity Increment Default objectRule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No JT_Org_Tsk.Task_Name General info Entityname JT_Org_Tsk Data type VarChar (50) Not null YES User-definedvariables Name Value Unique Fill factor Identity No Identity SeedIdentity Increment Default object Rule object RowGuidCol No Clusteredunique No Not for replication (Identity) No Not for replication (Check)No Data space for Unique Descending order (for Primary Key) NoDescending order (for Unique) No Override Null/NotNull by User Type NoGenerate Unique as unique Index No Collation for the column Maximumstorage size for varying types is “max” No Disabled check constraint NoLogs.Log_Alerts General info Entity name Logs Data type Char (20) Notnull NO User-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Logs.Log_Date General info Entity name Logs Data typeDateTime Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Logs.Log_Desc General info Entity nameLogs Data type Char (35) Not null NO User-defined variables Name ValueUnique Fill factor Identity No Identity Seed Identity Increment Defaultobject Rule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Logs.Log_Event General info Entity nameLogs Data type Char (25) Not null NO User-defined variables Name ValueUnique Fill factor Identity No Identity Seed Identity Increment Defaultobject Rule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Logs.Log_Evt_Type General info Entityname Logs Data type Char (20) Not null NO User-defined variables NameValue Unique Fill factor Identity No Identity Seed Identity IncrementDefault object Rule object RowGuidCol No Clustered unique No Not forreplication (Identity) No Not for replication (Check) No Data space forUnique Descending order (for Primary Key) No Descending order (forUnique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No Logs.Log_IDGeneral info Entity name Logs Data type UniqueIdentifier Not null YESUnique YES User-defined variables Name Value Unique Fill factor IdentityNo Identity Seed Identity Increment Default object Rule objectRowGuidCol Yes Clustered unique No Not for replication (Identity) No Notfor replication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Logs.Log_Priority General info Entity name Logs Data typeChar (20) Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Logs.Log_Sys General info Entity nameLogs Data type Char (20) Not null NO User-defined variables Name ValueUnique Fill factor Identity No Identity Seed Identity Increment Defaultobject Rule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Logs.Log_Text General info Entity nameLogs Data type Text Not null NO User-defined variables Name Value UniqueFill factor Identity No Identity Seed Identity Increment Default objectRule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Logs.Log_Time General info Entity nameLogs Data type DateTime Not null NO User-defined variables Name ValueUnique Fill factor Identity No Identity Seed Identity Increment Defaultobject Rule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Logs.Log_User General info Entity nameLogs Data type VarBinary (50) Not null NO User-defined variables NameValue Unique Fill factor Identity No Identity Seed Identity IncrementDefault object Rule object RowGuidCol No Clustered unique No Not forreplication (Identity) No Not for replication (Check) No Data space forUnique Descending order (for Primary Key) No Descending order (forUnique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint NoOrg_cht.Cht_M_Data General info Entity name Org_cht Data type Image Notnull NO User-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Org_cht.Cht_M_Desc General info Entity name Org_cht Datatype Text Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Org_cht.Cht_M_Name General info Entityname Org_cht Data type VarChar (50) Not null NO User-defined variablesName Value Unique Fill factor Identity No Identity Seed IdentityIncrement Default object Rule object RowGuidCol No Clustered unique NoNot for replication (Identity) No Not for replication (Check) No Dataspace for Unique Descending order (for Primary Key) No Descending order(for Unique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint NoOrg_cht.Cht_mast_ID General info Entity name Org_cht Data typeUniqueIdentifier Not null YES Unique YES User-defined variables NameValue Unique Fill factor Identity No Identity Seed Identity IncrementDefault object Rule object RowGuidCol Yes Clustered unique No Not forreplication (Identity) No Not for replication (Check) No Data space forUnique Descending order (for Primary Key) No Descending order (forUnique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No Org_cht.EVT_IDGeneral info Entity name Org_cht Data type UniqueIdentifier Not null YESUser-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Organization.Org_Address General info Entity nameOrganization Data type VarChar (64) Not null NO User-defined variablesName Value Unique Fill factor Identity No Identity Seed IdentityIncrement Default object Rule object RowGuidCol No Clustered unique NoNot for replication (Identity) No Not for replication (Check) No Dataspace for Unique Descending order (for Primary Key) No Descending order(for Unique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint NoOrganization.Org_city General info Entity name Organization Data typeVarChar (35) Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Organization.Org_ID General info Entityname Organization Data type UniqueIdentifier Not null YES Unique YESUser-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColYes Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Organization.Org_Name General info Entity nameOrganization Data type VarChar (50) Not null NO User-defined variablesName Value Unique Fill factor Identity No Identity Seed IdentityIncrement Default object Rule object RowGuidCol No Clustered unique NoNot for replication (Identity) No Not for replication (Check) No Dataspace for Unique Descending order (for Primary Key) No Descending order(for Unique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint NoOrganization.Org_POC General info Entity name Organization Data typeVarChar (50) Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Organization.Org_State General infoEntity name Organization Data type Char (20) Not null NO User-definedvariables Name Value Unique Fill factor Identity No Identity SeedIdentity Increment Default object Rule object RowGuidCol No Clusteredunique No Not for replication (Identity) No Not for replication (Check)No Data space for Unique Descending order (for Primary Key) NoDescending order (for Unique) No Override Null/NotNull by User Type NoGenerate Unique as unique Index No Collation for the column Maximumstorage size for varying types is “max” No Disabled check constraint NoOrganization.Org_Zip General info Entity name Organization Data typeSmallInt Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Package.EVT_ID General info Entity namePackage Data type UniqueIdentifier Not null YES User-defined variablesName Value Unique Fill factor Identity No Identity Seed IdentityIncrement Default object Rule object RowGuidCol No Clustered unique NoNot for replication (Identity) No Not for replication (Check) No Dataspace for Unique Descending order (for Primary Key) No Descending order(for Unique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint NoPackage.Package_ID General info Entity name Package Data typeUniqueIdentifier Not null YES Unique YES User-defined variables NameValue Unique Fill factor Identity No Identity Seed Identity IncrementDefault object Rule object RowGuidCol Yes Clustered unique No Not forreplication (Identity) No Not for replication (Check) No Data space forUnique Descending order (for Primary Key) No Descending order (forUnique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No Package.Pkg_defGeneral info Entity name Package Data type Char (20) Not null NOUser-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Package.Pkg_E_Date General info Entity name Package Datatype DateTime Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Package.Pkg_Name General info Entityname Package Data type VarChar (50) Not null NO User-defined variablesName Value Unique Fill factor Identity No Identity Seed IdentityIncrement Default object Rule object RowGuidCol No Clustered unique NoNot for replication (Identity) No Not for replication (Check) No Dataspace for Unique Descending order (for Primary Key) No Descending order(for Unique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint NoPackage.Pkg_S_Date General info Entity name Package Data type DateTimeNot null NO User-defined variables Name Value Unique Fill factorIdentity No Identity Seed Identity Increment Default object Rule objectRowGuidCol No Clustered unique No Not for replication (Identity) No Notfor replication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Package.Pkg_Status General info Entity name Package Datatype Char (20) Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Package.Pkg_type General info Entityname Package Data type Char (20) Not null NO User-defined variables NameValue Unique Fill factor Identity No Identity Seed Identity IncrementDefault object Rule object RowGuidCol No Clustered unique No Not forreplication (Identity) No Not for replication (Check) No Data space forUnique Descending order (for Primary Key) No Descending order (forUnique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No Personnel.Org_IDGeneral info Entity name Personnel Data type UniqueIdentifier Not nullYES User-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Personnel.Pers_Blood General info Entity name PersonnelData type Char (10) Not null NO User-defined variables Name Value UniqueFill factor Identity No Identity Seed Identity Increment Default objectRule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Personnel.Pers_Clear General info Entityname Personnel Data type Char (15) Not null NO User-defined variablesName Value Unique Fill factor Identity No Identity Seed IdentityIncrement Default object Rule object RowGuidCol No Clustered unique NoNot for replication (Identity) No Not for replication (Check) No Dataspace for Unique Descending order (for Primary Key) No Descending order(for Unique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint NoPersonnel.Pers_Cost General info Entity name Personnel Data type MoneyNot null NO User-defined variables Name Value Unique Fill factorIdentity No Identity Seed Identity Increment Default object Rule objectRowGuidCol No Clustered unique No Not for replication (Identity) No Notfor replication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Personnel.Pers_DOB General info Entity name Personnel Datatype DateTime Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Personnel.Pers_Duty General info Entityname Personnel Data type VarChar (128) Not null NO User-definedvariables Name Value Unique Fill factor Identity No Identity SeedIdentity Increment Default object Rule object RowGuidCol No Clusteredunique No Not for replication (Identity) No Not for replication (Check)No Data space for Unique Descending order (for Primary Key) NoDescending order (for Unique) No Override Null/NotNull by User Type NoGenerate Unique as unique Index No Collation for the column Maximumstorage size for varying types is “max” No Disabled check constraint NoPersonnel.Pers_FName General info Entity name Personnel Data type Char(20) Not null NO User-defined variables Name Value Unique Fill factorIdentity No Identity Seed Identity Increment Default object Rule objectRowGuidCol No Clustered unique No Not for replication (Identity) No Notfor replication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Personnel.Pers_ID General info Entity name Personnel Datatype UniqueIdentifier Not null YES Unique YES User-defined variablesName Value Unique Fill factor Identity No Identity Seed IdentityIncrement Default object Rule object RowGuidCol No Clustered unique NoNot for replication (Identity) No Not for replication (Check) No Dataspace for Unique Descending order (for Primary Key) No Descending order(for Unique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint NoPersonnel.Pers_LName General info Entity name Personnel Data type Char(20) Not null NO User-defined variables Name Value Unique Fill factorIdentity No Identity Seed Identity Increment Default object Rule objectRowGuidCol No Clustered unique No Not for replication (Identity) No Notfor replication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Personnel.Pers_Status General info Entity name PersonnelData type Char (15) Not null NO User-defined variables Name Value UniqueFill factor Identity No Identity Seed Identity Increment Default objectRule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Readers.Read_Active General info Entityname Readers Data type Bit Not null NO User-defined variables Name ValueUnique Fill factor Identity No Identity Seed Identity Increment Defaultobject Rule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Readers.Read_Desc General info Entityname Readers Data type Text Not null NO User-defined variables NameValue Unique Fill factor Identity No Identity Seed Identity IncrementDefault object Rule object RowGuidCol No Clustered unique No Not forreplication (Identity) No Not for replication (Check) No Data space forUnique Descending order (for Primary Key) No Descending order (forUnique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No Readers.Read_GrpGeneral info Entity name Readers Data type VarChar (50) Not null NOUser-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Readers.Read_ID General info Entity name Readers Data typeUniqueIdentifier Not null YES Unique YES User-defined variables NameValue Unique Fill factor Identity No Identity Seed Identity IncrementDefault object Rule object RowGuidCol Yes Clustered unique No Not forreplication (Identity) No Not for replication (Check) No Data space forUnique Descending order (for Primary Key) No Descending order (forUnique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No Readers.Read_LatGeneral info Entity name Readers Data type Char (25) Not null NOUser-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Readers.Read_long General info Entity name Readers Datatype Char (25) Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Readers.Read_Name General info Entityname Readers Data type VarChar (50) Not null NO User-defined variablesName Value Unique Fill factor Identity No Identity Seed IdentityIncrement Default object Rule object RowGuidCol No Clustered unique NoNot for replication (Identity) No Not for replication (Check) No Dataspace for Unique Descending order (for Primary Key) No Descending order(for Unique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint NoReps_agency.AR_Agency General info Entity name Reps_agency Data typeVarChar (50) Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Reps_agency.AR_End General info Entityname Reps_agency Data type DateTime Not null NO User-defined variablesName Value Unique Fill factor Identity No Identity Seed IdentityIncrement Default object Rule object RowGuidCol No Clustered unique NoNot for replication (Identity) No Not for replication (Check) No Dataspace for Unique Descending order (for Primary Key) No Descending order(for Unique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint NoReps_agency.AR_FName General info Entity name Reps_agency Data type Char(20) Not null NO User-defined variables Name Value Unique Fill factorIdentity No Identity Seed Identity Increment Default object Rule objectRowGuidCol No Clustered unique No Not for replication (Identity) No Notfor replication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Reps_agency.AR_LName General info Entity name Reps_agencyData type Char (20) Not null NO User-defined variables Name Value UniqueFill factor Identity No Identity Seed Identity Increment Default objectRule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Reps_agency.AR_Rem General info Entityname Reps_agency Data type Text Not null NO User-defined variables NameValue Unique Fill factor Identity No Identity Seed Identity IncrementDefault object Rule object RowGuidCol No Clustered unique No Not forreplication (Identity) No Not for replication (Check) No Data space forUnique Descending order (for Primary Key) No Descending order (forUnique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint NoReps_agency.AR_Start General info Entity name Reps_agency Data typeDateTime Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Reps_agency.ARep_ID General info Entityname Reps_agency Data type UniqueIdentifier Not null YES Unique YESUser-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColYes Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Reps_agency.EVT_ID General info Entity name Reps_agencyData type UniqueIdentifier Not null YES User-defined variables NameValue Unique Fill factor Identity No Identity Seed Identity IncrementDefault object Rule object RowGuidCol No Clustered unique No Not forreplication (Identity) No Not for replication (Check) No Data space forUnique Descending order (for Primary Key) No Descending order (forUnique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No Reps_Tech.EVT_IDGeneral info Entity name Reps_Tech Data type UniqueIdentifier Not nullYES User-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Reps_Tech.TR_Agency General info Entity name Reps_TechData type VarChar (50) Not null NO User-defined variables Name ValueUnique Fill factor Identity No Identity Seed Identity Increment Defaultobject Rule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Reps_Tech.TR_End General info Entityname Reps_Tech Data type DateTime Not null NO User-defined variablesName Value Unique Fill factor Identity No Identity Seed IdentityIncrement Default object Rule object RowGuidCol No Clustered unique NoNot for replication (Identity) No Not for replication (Check) No Dataspace for Unique Descending order (for Primary Key) No Descending order(for Unique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint NoReps_Tech.TR_FName General info Entity name Reps_Tech Data type Char(20) Not null NO User-defined variables Name Value Unique Fill factorIdentity No Identity Seed Identity Increment Default object Rule objectRowGuidCol No Clustered unique No Not for replication (Identity) No Notfor replication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Reps_Tech.TR_ID General info Entity name Reps_Tech Datatype UniqueIdentifier Not null YES Unique YES User-defined variablesName Value Unique Fill factor Identity No Identity Seed IdentityIncrement Default object Rule object RowGuidCol Yes Clustered unique NoNot for replication (Identity) No Not for replication (Check) No Dataspace for Unique Descending order (for Primary Key) No Descending order(for Unique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint NoReps_Tech.TR_LName General info Entity name Reps_Tech Data type Char(20) Not null NO User-defined variables Name Value Unique Fill factorIdentity No Identity Seed Identity Increment Default object Rule objectRowGuidCol No Clustered unique No Not for replication (Identity) No Notfor replication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Reps_Tech.TR_Rem General info Entity name Reps_Tech Datatype Text Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Reps_Tech.TR_Start General info Entityname Reps_Tech Data type DateTime Not null NO User-defined variablesName Value Unique Fill factor Identity No Identity Seed IdentityIncrement Default object Rule object RowGuidCol No Clustered unique NoNot for replication (Identity) No Not for replication (Check) No Dataspace for Unique Descending order (for Primary Key) No Descending order(for Unique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No Schedule.EVT_IDGeneral info Entity name Schedule Data type UniqueIdentifier Not nullYES User-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Schedule.Sched_Data General info Entity name Schedule Datatype Binary (512) Not null NO User-defined variables Name Value UniqueFill factor Identity No Identity Seed Identity Increment Default objectRule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Schedule.Sched_ID General info Entityname Schedule Data type UniqueIdentifier Not null YES Unique YESUser-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColYes Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Schedule.Sched_Name General info Entity name Schedule Datatype VarChar (50) Not null NO User-defined variables Name Value UniqueFill factor Identity No Identity Seed Identity Increment Default objectRule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Sens_Pts.EVT_ID General info Entity nameSens_Pts Data type UniqueIdentifier Not null YES User-defined variablesName Value Unique Fill factor Identity No Identity Seed IdentityIncrement Default object Rule object RowGuidCol No Clustered unique NoNot for replication (Identity) No Not for replication (Check) No Dataspace for Unique Descending order (for Primary Key) No Descending order(for Unique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No Sens_Pts.PT_DateGeneral info Entity name Sens_Pts Data type DateTime Not null NOUser-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Sens_Pts.Pt_ID General info Entity name Sens_Pts Data typeUniqueIdentifier Not null YES Unique YES User-defined variables NameValue Unique Fill factor Identity No Identity Seed Identity IncrementDefault object Rule object RowGuidCol No Clustered unique No Not forreplication (Identity) No Not for replication (Check) No Data space forUnique Descending order (for Primary Key) No Descending order (forUnique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No Sens_Pts.PT_TimeGeneral info Entity name Sens_Pts Data type Char (1) Not null NOUser-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Sens_Pts.PT_Value General info Entity name Sens_Pts Datatype Char (1) Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Sens_Pts.Sens_ID General info Entityname Sens_Pts Data type UniqueIdentifier Not null YES User-definedvariables Name Value Unique Fill factor Identity No Identity SeedIdentity Increment Default object Rule object RowGuidCol No Clusteredunique No Not for replication (Identity) No Not for replication (Check)No Data space for Unique Descending order (for Primary Key) NoDescending order (for Unique) No Override Null/NotNull by User Type NoGenerate Unique as unique Index No Collation for the column Maximumstorage size for varying types is “max” No Disabled check constraint NoSensor.EVT_ID General info Entity name Sensor Data type UniqueIdentifierNot null YES User-defined variables Name Value Unique Fill factorIdentity No Identity Seed Identity Increment Default object Rule objectRowGuidCol No Clustered unique No Not for replication (Identity) No Notfor replication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Sensor.Sens_Close_Date General info Entity name SensorData type Char (1) Not null NO User-defined variables Name Value UniqueFill factor Identity No Identity Seed Identity Increment Default objectRule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Sensor.Sens_Close_Time General infoEntity name Sensor Data type DateTime Not null NO User-defined variablesName Value Unique Fill factor Identity No Identity Seed IdentityIncrement Default object Rule object RowGuidCol No Clustered unique NoNot for replication (Identity) No Not for replication (Check) No Dataspace for Unique Descending order (for Primary Key) No Descending order(for Unique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint NoSensor.Sens_Deploy_Date General info Entity name Sensor Data typeDateTime Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Sensor.Sens_Deploy_Time General infoEntity name Sensor Data type DateTime Not null NO User-defined variablesName Value Unique Fill factor Identity No Identity Seed IdentityIncrement Default object Rule object RowGuidCol No Clustered unique NoNot for replication (Identity) No Not for replication (Check) No Dataspace for Unique Descending order (for Primary Key) No Descending order(for Unique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No Sensor.Sens_DescGeneral info Entity name Sensor Data type Text Not null NO User-definedvariables Name Value Unique Fill factor Identity No Identity SeedIdentity Increment Default object Rule object RowGuidCol No Clusteredunique No Not for replication (Identity) No Not for replication (Check)No Data space for Unique Descending order (for Primary Key) NoDescending order (for Unique) No Override Null/NotNull by User Type NoGenerate Unique as unique Index No Collation for the column Maximumstorage size for varying types is “max” No Disabled check constraint NoSensor.Sens_ID General info Entity name Sensor Data typeUniqueIdentifier Not null YES Unique YES User-defined variables NameValue Unique Fill factor Identity No Identity Seed Identity IncrementDefault object Rule object RowGuidCol No Clustered unique No Not forreplication (Identity) No Not for replication (Check) No Data space forUnique Descending order (for Primary Key) No Descending order (forUnique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No Sensor.Sens_LatGeneral info Entity name Sensor Data type Char (45) Not null NOUser-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Sensor.Sens_Long General info Entity name Sensor Data typeChar (45) Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Sensor.Sens_Name General info Entityname Sensor Data type VarChar (50) Not null NO User-defined variablesName Value Unique Fill factor Identity No Identity Seed IdentityIncrement Default object Rule object RowGuidCol No Clustered unique NoNot for replication (Identity) No Not for replication (Check) No Dataspace for Unique Descending order (for Primary Key) No Descending order(for Unique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint NoSensor.Sens_Remarks General info Entity name Sensor Data type Text Notnull NO User-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Sensor.Sens_Type General info Entity name Sensor Data typeChar (1) Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No SITREP.EVT_ID General info Entity nameSITREP Data type UniqueIdentifier Not null YES User-defined variablesName Value Unique Fill factor Identity No Identity Seed IdentityIncrement Default object Rule object RowGuidCol No Clustered unique NoNot for replication (Identity) No Not for replication (Check) No Dataspace for Unique Descending order (for Primary Key) No Descending order(for Unique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No SITREP.Sit_ActGeneral info Entity name SITREP Data type VarChar (64) Not null NOUser-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No SITREP.Sit_Agency General info Entity name SITREP Datatype Char (1) Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No SITREP.Sit_Asset General info Entityname SITREP Data type Char (1) Not null NO User-defined variables NameValue Unique Fill factor Identity No Identity Seed Identity IncrementDefault object Rule object RowGuidCol No Clustered unique No Not forreplication (Identity) No Not for replication (Check) No Data space forUnique Descending order (for Primary Key) No Descending order (forUnique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No SITREP.Sit_AssetsGeneral info Entity name SITREP Data type VarChar (64) Not null NOUser-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No SITREP.Sit_Date General info Entity name SITREP Data typeDateTime Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No SITREP.Sit_Elem General info Entity nameSITREP Data type VarChar (64) Not null NO User-defined variables NameValue Unique Fill factor Identity No Identity Seed Identity IncrementDefault object Rule object RowGuidCol No Clustered unique No Not forreplication (Identity) No Not for replication (Check) No Data space forUnique Descending order (for Primary Key) No Descending order (forUnique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No SITREP.Sit_IDGeneral info Entity name SITREP Data type UniqueIdentifier Not null YESUnique YES User-defined variables Name Value Unique Fill factor IdentityNo Identity Seed Identity Increment Default object Rule objectRowGuidCol No Clustered unique No Not for replication (Identity) No Notfor replication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No SITREP.Sit_Imp General info Entity name SITREP Data typeVarChar (64) Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No SITREP.Sit_Loc General info Entity nameSITREP Data type VarChar (64) Not null NO User-defined variables NameValue Unique Fill factor Identity No Identity Seed Identity IncrementDefault object Rule object RowGuidCol No Clustered unique No Not forreplication (Identity) No Not for replication (Check) No Data space forUnique Descending order (for Primary Key) No Descending order (forUnique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No SITREP.Sit_NameGeneral info Entity name SITREP Data type VarChar (50) Not null NOUser-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No SITREP.Sit_rem General info Entity name SITREP Data typeText Not null NO User-defined variables Name Value Unique Fill factorIdentity No Identity Seed Identity Increment Default object Rule objectRowGuidCol No Clustered unique No Not for replication (Identity) No Notfor replication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No SITREP.Sit_sev General info Entity name SITREP Data typeVarChar (64) Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No SITREP.Sit_Situation General info Entityname SITREP Data type VarChar (64) Not null NO User-defined variablesName Value Unique Fill factor Identity No Identity Seed IdentityIncrement Default object Rule object RowGuidCol No Clustered unique NoNot for replication (Identity) No Not for replication (Check) No Dataspace for Unique Descending order (for Primary Key) No Descending order(for Unique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No SITREP.Sit_thtGeneral info Entity name SITREP Data type VarChar (64) Not null NOUser-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No SITREP.Sit_Time General info Entity name SITREP Data typeChar (1) Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Tasks.Task_Agency General info Entityname Tasks Data type Char (1) Not null NO User-defined variables NameValue Unique Fill factor Identity No Identity Seed Identity IncrementDefault object Rule object RowGuidCol No Clustered unique No Not forreplication (Identity) No Not for replication (Check) No Data space forUnique Descending order (for Primary Key) No Descending order (forUnique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No Tasks.Task_Ass_ByGeneral info Entity name Tasks Data type VarChar (1) Not null NOUser-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Tasks.Task_Comp_Date General info Entity name Tasks Datatype Char (1) Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Tasks.Task_Desc General info Entity nameTasks Data type Text Not null NO User-defined variables Name ValueUnique Fill factor Identity No Identity Seed Identity Increment Defaultobject Rule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Tasks.Task_ID General info Entity nameTasks Data type UniqueIdentifier Not null YES Unique YES User-definedvariables Name Value Unique Fill factor Identity No Identity SeedIdentity Increment Default object Rule object RowGuidCol Yes Clusteredunique No Not for replication (Identity) No Not for replication (Check)No Data space for Unique Descending order (for Primary Key) NoDescending order (for Unique) No Override Null/NotNull by User Type NoGenerate Unique as unique Index No Collation for the column Maximumstorage size for varying types is “max” No Disabled check constraint NoTasks.Task_Iss_Date General info Entity name Tasks Data type DateTimeNot null NO User-defined variables Name Value Unique Fill factorIdentity No Identity Seed Identity Increment Default object Rule objectRowGuidCol No Clustered unique No Not for replication (Identity) No Notfor replication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Tasks.Task_Name General info Entity name Tasks Data typeVarChar (50) Not null YES Unique YES User-defined variables Name ValueUnique Fill factor Identity No Identity Seed Identity Increment Defaultobject Rule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Tasks.Task_No_Later_Date General infoEntity name Tasks Data type Char (1) Not null NO User-defined variablesName Value Unique Fill factor Identity No Identity Seed IdentityIncrement Default object Rule object RowGuidCol No Clustered unique NoNot for replication (Identity) No Not for replication (Check) No Dataspace for Unique Descending order (for Primary Key) No Descending order(for Unique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No Tasks.Task_RemGeneral info Entity name Tasks Data type Char (1) Not null NOUser-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Video.EVT_ID General info Entity name Video Data typeUniqueIdentifier Not null YES User-defined variables Name Value UniqueFill factor Identity No Identity Seed Identity Increment Default objectRule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Video.Vid_Data General info Entity nameVideo Data type Binary (512) Not null NO User-defined variables NameValue Unique Fill factor Identity No Identity Seed Identity IncrementDefault object Rule object RowGuidCol No Clustered unique No Not forreplication (Identity) No Not for replication (Check) No Data space forUnique Descending order (for Primary Key) No Descending order (forUnique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No Video.Vid_DateGeneral info Entity name Video Data type DateTime Not null NOUser-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Video.Vid_Desc General info Entity name Video Data typeText Not null NO User-defined variables Name Value Unique Fill factorIdentity No Identity Seed Identity Increment Default object Rule objectRowGuidCol No Clustered unique No Not for replication (Identity) No Notfor replication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Video.Vid_ID General info Entity name Video Data typeUniqueIdentifier Not null YES Unique YES User-defined variables NameValue Unique Fill factor Identity No Identity Seed Identity IncrementDefault object Rule object RowGuidCol Yes Clustered unique No Not forreplication (Identity) No Not for replication (Check) No Data space forUnique Descending order (for Primary Key) No Descending order (forUnique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No Video.Vid_NameGeneral info Entity name Video Data type VarChar (50) Not null NOUser-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No Video.Vid_Time General info Entity name Video Data typeDateTime Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No VOIP.EVT_ID General info Entity nameVOIP Data type UniqueIdentifier Not null YES User-defined variables NameValue Unique Fill factor Identity No Identity Seed Identity IncrementDefault object Rule object RowGuidCol No Clustered unique No Not forreplication (Identity) No Not for replication (Check) No Data space forUnique Descending order (for Primary Key) No Descending order (forUnique) No Override Null/NotNull by User Type No Generate Unique asunique Index No Collation for the column Maximum storage size forvarying types is “max” No Disabled check constraint No VOIP.VOIP_TimeGeneral info Entity name VOIP Data type DateTime Not null NOUser-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No VOIP.VOIP_Data General info Entity name VOIP Data typeBinary (512) Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No VOIP.VOIP_Date General info Entity nameVOIP Data type DateTime Not null NO User-defined variables Name ValueUnique Fill factor Identity No Identity Seed Identity Increment Defaultobject Rule object RowGuidCol No Clustered unique No Not for replication(Identity) No Not for replication (Check) No Data space for UniqueDescending order (for Primary Key) No Descending order (for Unique) NoOverride Null/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No VOIP.VOIP_ID General info Entity nameVOIP Data type UniqueIdentifier Not null YES Unique YES User-definedvariables Name Value Unique Fill factor Identity No Identity SeedIdentity Increment Default object Rule object RowGuidCol Yes Clusteredunique No Not for replication (Identity) No Not for replication (Check)No Data space for Unique Descending order (for Primary Key) NoDescending order (for Unique) No Override Null/NotNull by User Type NoGenerate Unique as unique Index No Collation for the column Maximumstorage size for varying types is “max” No Disabled check constraint NoVOIP.VOIP_Name General info Entity name VOIP Data type VarChar (50) Notnull NO User-defined variables Name Value Unique Fill factor Identity NoIdentity Seed Identity Increment Default object Rule object RowGuidColNo Clustered unique No Not for replication (Identity) No Not forreplication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No VOIP.VOIP_Rem General info Entity name VOIP Data type TextNot null NO User-defined variables Name Value Unique Fill factorIdentity No Identity Seed Identity Increment Default object Rule objectRowGuidCol No Clustered unique No Not for replication (Identity) No Notfor replication (Check) No Data space for Unique Descending order (forPrimary Key) No Descending order (for Unique) No Override Null/NotNullby User Type No Generate Unique as unique Index No Collation for thecolumn Maximum storage size for varying types is “max” No Disabled checkconstraint No VOIP.VOIP_Sens General info Entity name VOIP Data typeChar (15) Not null NO User-defined variables Name Value Unique Fillfactor Identity No Identity Seed Identity Increment Default object Ruleobject RowGuidCol No Clustered unique No Not for replication (Identity)No Not for replication (Check) No Data space for Unique Descending order(for Primary Key) No Descending order (for Unique) No OverrideNull/NotNull by User Type No Generate Unique as unique Index NoCollation for the column Maximum storage size for varying types is “max”No Disabled check constraint No Relationship list RelationshipRelationship name type Parent entity Child entity Card. Relationship12Identifying Organization JT org_evt 1:N Relationship122 IdentifyingEvents Audio 1:N Relationship152 Identifying Events JT accevt 1:NRelationship162 Identifying Access JT accevt 1:N Relationship22Identifying Sensor Sens_Pts 1:N Relationship22 Identifying Events JTorg_evt 1:N Relationship23 Identifying Events Org_cht 1:N Relationship24Identifying Events SITREP 1:N Relationship25 Identifying EventsReps_agency 1:N Relationship26 Identifying Events Reps_Tech 1:NRelationship27 Identifying Organization Personnel 1:N Relationship272Identifying Personnel JT pers_certs 1:N Relationship28 IdentifyingOrganization Equipment 1:N Relationship282 Identifying Certs JTpers_certs 1:N Relationship29 Identifying Organization JT_Org_Tsk 1:NRelationship30 Identifying Tasks JT_Org_Tsk 1:N Relationship33Identifying Events Package 1:N Relationship34 Identifying Events Evt_Log1:N Relationship35 Identifying Events Historical 1:N Relationship36Identifying Events Docs 1:N Relationship37 Identifying Docs Doc_Auth 1:NRelationship38 Identifying Account JT_Acct_Read 1:N Relationship39Identifying Readers JT_Acct_Read 1:N Relationship40 Identifying AccountAD 1:N Relationship41 Identifying Account Acct_Hours 1:N Relationship42Identifying Events VOIP 1:N Relationship43 Identifying Events Schedule1:N Relationship44 Identifying Events Video 1:N Relationship62Identifying Events Sensor 1:N Relationship92 Identifying Events Graph1:N Relationship ‘Relationship12’ General info Relationship typeidentifying Cardinality 1:N Parent entity Organization Child entity JTorg_evt Partiality Parent mandatory Child mandatory Referentialintegrity Insert Update Delete Parent — RESTRICT RESTRICT Child NONENONE — Keys Parent key Child key Org_ID Org_ID User-defined variablesName Value Not for replication No Disabled foreign key constraint NoRelationship ‘Relationship122’ General info Relationship typeidentifying Cardinality 1:N Parent entity Events Child entity AudioPartiality Parent mandatory Child mandatory Referential integrity InsertUpdate Delete Parent — RESTRICT RESTRICT Child NONE NONE — Keys Parentkey Child key EVT_ID EVT_ID User-defined variables Name Value Not forreplication No Disabled foreign key constraint No Relationship‘Relationship152’ General info Relationship type identifying Cardinality1:N Parent entity Events Child entity JT accevt Partiality Parentmandatory Child mandatory Referential integrity Insert Update DeleteParent — RESTRICT RESTRICT Child NONE NONE — Keys Parent key Child keyEVT_ID EVT_ID User-defined variables Name Value Not for replication NoDisabled foreign key constraint No Relationship ‘Relationship162’General info Relationship type identifying Cardinality 1:N Parent entityAccess Child entity JT accevt Partiality Parent mandatory Childmandatory Referential integrity Insert Update Delete Parent — RESTRICTRESTRICT Child NONE NONE — Keys Parent key Child key Access_ID Access_IDUser-defined variables Name Value Not for replication No Disabledforeign key constraint No Relationship ‘Relationship22’ General infoRelationship type identifying Cardinality 1:N Parent entity Sensor Childentity Sens_Pts Partiality Parent mandatory Child mandatory Referentialintegrity Insert Update Delete Parent — RESTRICT RESTRICT Child NONENONE — Keys Parent key Child key EVT_ID EVT_ID Sens_ID Sens_IDUser-defined variables Name Value Not for replication No Disabledforeign key constraint No Relationship ‘Relationship22’ General infoRelationship type identifying Cardinality 1:N Parent entity Events Childentity JT org_evt Partiality Parent mandatory Child mandatoryReferential integrity Insert Update Delete Parent — RESTRICT RESTRICTChild NONE NONE — Keys Parent key Child key EVT_ID EVT_ID User-definedvariables Name Value Not for replication No Disabled foreign keyconstraint No Relationship ‘Relationship23’ General info Relationshiptype identifying Cardinality 1:N Parent entity Events Child entityOrg_cht Partiality Parent mandatory Child mandatory Referentialintegrity Insert Update Delete Parent — RESTRICT RESTRICT Child NONENONE — Keys Parent key Child key EVT_ID EVT_ID User-defined variablesName Value Not for replication No Disabled foreign key constraint NoRelationship ‘Relationship24’ General info Relationship type identifyingCardinality 1:N Parent entity Events Child entity SITREP PartialityParent mandatory Child mandatory Referential integrity Insert UpdateDelete Parent — RESTRICT RESTRICT Child NONE NONE — Keys Parent keyChild key EVT_ID EVT_ID User-defined variables Name Value Not forreplication No Disabled foreign key constraint No Relationship‘Relationship25’ General info Relationship type identifying Cardinality1:N Parent entity Events Child entity Reps_agency Partiality Parentmandatory Child mandatory Referential integrity Insert Update DeleteParent — RESTRICT RESTRICT Child NONE NONE — Keys Parent key Child keyEVT_ID EVT_ID User-defined variables Name Value Not for replication NoDisabled foreign key constraint No Relationship ‘Relationship26’ Generalinfo Relationship type identifying Cardinality 1:N Parent entity EventsChild entity Reps_Tech Partiality Parent mandatory Child mandatoryReferential integrity Insert Update Delete Parent — RESTRICT RESTRICTChild NONE NONE — Keys Parent key Child key EVT_ID EVT_ID User-definedvariables Name Value Not for replication No Disabled foreign keyconstraint No Relationship ‘Relationship27’ General info Relationshiptype identifying Cardinality 1:N Parent entity Organization Child entityPersonnel Partiality Parent mandatory Child mandatory Referentialintegrity Insert Update Delete Parent — RESTRICT RESTRICT Child NONENONE — Keys Parent key Child key Org_ID Org_ID User-defined variablesName Value Not for replication No Disabled foreign key constraint NoRelationship ‘Relationship272’ General info Relationship typeidentifying Cardinality 1:N Parent entity Personnel Child entity JTpers_certs Partiality Parent mandatory Child mandatory Referentialintegrity Insert Update Delete Parent — RESTRICT RESTRICT Child NONENONE — Keys Parent key Child key Org_ID Org_ID Pers_ID Pers_IDUser-defined variables Name Value Not for replication No Disabledforeign key constraint No Relationship ‘Relationship28’ General infoRelationship type identifying Cardinality 1:N Parent entity OrganizationChild entity Equipment Partiality Parent mandatory Child mandatoryReferential integrity Insert Update Delete Parent — RESTRICT RESTRICTChild NONE NONE — Keys Parent key Child key Org_ID Org_ID User-definedvariables Name Value Not for replication No Disabled foreign keyconstraint No Relationship ‘Relationship282’ General info Relationshiptype identifying Cardinality 1:N Parent entity Certs Child entity JTpers_certs Partiality Parent mandatory Child mandatory Referentialintegrity Insert Update Delete Parent — RESTRICT RESTRICT Child NONENONE — Keys Parent key Child key Cert_ID Cert_ID User-defined variablesName Value Not for replication No Disabled foreign key constraint NoRelationship ‘Relationship29’ General info Relationship type identifyingCardinality 1:N Parent entity Organization Child entity JT_Org_TskPartiality Parent mandatory Child mandatory Referential integrity InsertUpdate Delete Parent — RESTRICT RESTRICT Child NONE NONE — Keys Parentkey Child key Org_ID Org_ID User-defined variables Name Value Not forreplication No Disabled foreign key constraint No Relationship‘Relationship30’ General info Relationship type identifying Cardinality1:N Parent entity Tasks Child entity JT_Org_Tsk Partiality Parentmandatory Child mandatory Referential integrity Insert Update DeleteParent — RESTRICT RESTRICT Child NONE NONE — Keys Parent key Child keyTask_ID Task_ID Task_Name Task_Name User-defined variables Name ValueNot for replication No Disabled foreign key constraint No Relationship‘Relationship33’ General info Relationship type identifying Cardinality1:N Parent entity Events Child entity Package Partiality Parentmandatory Child mandatory Referential integrity Insert Update DeleteParent — RESTRICT RESTRICT Child NONE NONE — Keys Parent key Child keyEVT_ID EVT_ID User-defined variables Name Value Not for replication NoDisabled foreign key constraint No Relationship ‘Relationship34’ Generalinfo Relationship type identifying Cardinality 1:N Parent entity EventsChild entity Evt_Log Partiality Parent mandatory Child mandatoryReferential integrity Insert Update Delete Parent — RESTRICT RESTRICTChild NONE NONE — Keys Parent key Child key EVT_ID EVT_ID User-definedvariables Name Value Not for replication No Disabled foreign keyconstraint No Relationship ‘Relationship35’ General info Relationshiptype identifying Cardinality 1:N Parent entity Events Child entityHistorical Partiality Parent mandatory Child mandatory Referentialintegrity Insert Update Delete Parent — RESTRICT RESTRICT Child NONENONE — Keys Parent key Child key EVT_ID EVT_ID User-defined variablesName Value Not for replication No Disabled foreign key constraint NoRelationship ‘Relationship36’ General info Relationship type identifyingCardinality 1:N Parent entity Events Child entity Docs Partiality Parentmandatory Child mandatory Referential integrity Insert Update DeleteParent — CASCADE CASCADE Child NONE NONE — Keys Parent key Child keyEVT_ID EVT_ID User-defined variables Name Value Not for replication NoDisabled foreign key constraint No Relationship ‘Relationship37’ Generalinfo Relationship type identifying Cardinality 1:N Parent entity DocsChild entity Doc_Auth Partiality Parent mandatory Child mandatoryReferential integrity Insert Update Delete Parent — CASCADE CASCADEChild NONE NONE — Keys Parent key Child key Doc_ID Doc_ID EVT_ID EVT_IDUser-defined variables Name Value Not for replication No Disabledforeign key constraint No Relationship ‘Relationship38’ General infoRelationship type identifying Cardinality 1:N Parent entity AccountChild entity JT_Acct_Read Partiality Parent mandatory Child mandatoryReferential integrity Insert Update Delete Parent — CASCADE CASCADEChild NONE NONE — Keys Parent key Child key Acct_ID Acct_ID User-definedvariables Name Value Not for replication No Disabled foreign keyconstraint No Relationship ‘Relationship39’ General info Relationshiptype identifying Cardinality 1:N Parent entity Readers Child entityJT_Acct_Read Partiality Parent mandatory Child mandatory Referentialintegrity Insert Update Delete Parent — CASCADE CASCADE Child NONE NONE— Keys Parent key Child key Read_ID Read_ID User-defined variables NameValue Not for replication No Disabled foreign key constraint NoRelationship ‘Relationship40’ General info Relationship type identifyingCardinality 1:N Parent entity Account Child entity AD Partiality Parentmandatory Child mandatory Referential integrity Insert Update DeleteParent — CASCADE CASCADE Child NONE NONE — Keys Parent key Child keyAcct_ID Acct_ID User-defined variables Name Value Not for replication NoDisabled foreign key constraint No Relationship ‘Relationship41’ Generalinfo Relationship type identifying Cardinality 1:N Parent entity AccountChild entity Acct_Hours Partiality Parent mandatory Child mandatoryReferential integrity Insert Update Delete Parent — CASCADE CASCADEChild NONE NONE — Keys Parent key Child key Acct_ID Acct_ID User-definedvariables Name Value Not for replication No Disabled foreign keyconstraint No Relationship ‘Relationship42’ General info Relationshiptype identifying Cardinality 1:N Parent entity Events Child entity VOIPPartiality Parent mandatory Child mandatory Referential integrity InsertUpdate Delete Parent — CASCADE CASCADE Child NONE NONE — Keys Parent keyChild key EVT_ID EVT_ID User-defined variables Name Value Not forreplication No Disabled foreign key constraint No Relationship‘Relationship43’ General info Relationship type identifying Cardinality1:N Parent entity Events Child entity Schedule Partiality Parentmandatory Child mandatory Referential integrity Insert Update DeleteParent — CASCADE CASCADE Child NONE NONE — Keys Parent key Child keyEVT_ID EVT_ID User-defined variables Name Value Not for replication NoDisabled foreign key constraint No Relationship ‘Relationship44’ Generalinfo Relationship type identifying Cardinality 1:N Parent entity EventsChild entity Video Partiality Parent mandatory Child mandatoryReferential integrity Insert Update Delete Parent — CASCADE CASCADEChild NONE NONE — Keys Parent key Child key EVT_ID EVT_ID User-definedvariables Name Value Not for replication No Disabled foreign keyconstraint No Relationship ‘Relationship62’ General info Relationshiptype identifying Cardinality 1:N Parent entity Events Child entitySensor Partiality Parent mandatory Child mandatory Referential integrityInsert Update Delete Parent — RESTRICT RESTRICT Child NONE NONE — KeysParent key Child key EVT_ID EVT_ID User-defined variables Name Value Notfor replication No Disabled foreign key constraint No Relationship‘Relationship92’ General info Relationship type identifying Cardinality1:N Parent entity Events Child entity Graph Partiality Parent mandatoryChild mandatory Referential integrity Insert Update Delete Parent —RESTRICT RESTRICT Child NONE NONE — Keys Parent key Child key EVT_IDEVT_ID User-defined variables Name Value Not for replication No Disabledforeign key constraint No

1. An integrated physical and network security platform comprising: aunified credential having associated therewith information allowingaccess to one or more of a physical area and a computer system; asecurity management system including a data store and connectivitymodules allowing scalability and one or more connections to one or moreadditional security management systems, wherein the security managementsystem is capable of interfacing with one or more of an existingenterprise physical security system and an existing enterprise computersystem; an incident management perimeter access control and trackingsystem that manages one or more of personnel, tasks, equipment andaccess for a secure area. 2-46. (canceled)